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”

Tips on using the Matrix Visual in Microsoft Power BI

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.  I’ll build a GL Account Summary Matrix by month.

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.  I’ll build a GL Account Summary Matrix by month.

Continue reading “Tips on using the Matrix Visual in Microsoft Power BI”

Using Divide in a DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function (Divide) to alter a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Today’s DAX Expression:

Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)

Continue reading “Using Divide in a DAX Measures in Microsoft Power BI”

Treemap Bar Chart in Microsoft Power BI

 In this video, I’ll use a new custom visual called the Treemap Bar Chart.  It’s like the baby of the Clustered Column Visual and the Treemap Visual.  This was created by MAQ Software.

In this video, I’ll use a new custom visual called the Treemap Bar Chart.  It’s like the baby of the Clustered Column Visual and the Treemap Visual.  This was created by MAQ Software. https://maqsoftware.com/

Continue reading “Treemap Bar Chart in Microsoft Power BI”

Creating DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading “Creating DAX Measures in Microsoft Power BI”

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

Continue reading “Adding the Fields to a Visual’s Tooltips in Microsoft Power BI”