Underlying data in Microsoft Power BI Visuals

Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset. In this video, I’ll show you this very feature in a Clustered Column Chart.

Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset in Microsoft Power BI.  In this video, I’ll show you this very feature in a Clustered Column Chart.

Continue reading “Underlying data in Microsoft Power BI Visuals”

DAX 101 – Wrap up in Microsoft Power BI

In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals.

In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals.

Continue reading “DAX 101 – Wrap up in Microsoft Power BI”

Using DAX Measures across multiple Queries in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure creates the Salesperson Commission amount.  To achieve this, I’ll have to multiply two fields together that reside in different queries.

 

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure creates the Salesperson Commission amount.  To achieve this, I’ll have to multiply two fields together that reside in different queries.

Continue reading “Using DAX Measures across multiple Queries in Microsoft Power BI”

Using DAX Measures that Counts the number of Invoices in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to count the number of Invoices.  The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears.

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to count the number of Invoices.  The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears.

Continue reading “Using DAX Measures that Counts the number of Invoices in Microsoft Power BI”

Making Tooltips easier to read in Microsoft Power BI

In this video, I’ll show you how to format Tooltips in a Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

Continue reading “Making Tooltips easier to read in Microsoft Power BI”

Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to calculate the total sales price.  Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together.  Look at the two examples below and you’ll see why.

 

Math

In this Video, I’ll create a DAX (Data Analysis eXpression) Measure.  This measure will be used to calculate the total sales price.  Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together.  Look at the two examples below and you’ll see why.

Continue reading “Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI”

Creating a Conditional Title with DAX in Microsoft Power BI

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

In this Video, I’ll use DAX to make a visual Title be conditional based on a selection in a filter, using Microsoft Power BI.

Continue reading “Creating a Conditional Title with DAX in Microsoft Power BI”