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.
Month: May 2019
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.
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.
Today’s DAX Expression:
Gross Margin % := DIVIDE(SUM(‘Sales Line Items'[Gross Margin]), SUM(‘Sales Line Items'[Total Sales]), 0)
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. https://maqsoftware.com/
Line Chart Formatting 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.
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.
Adding the Q&A Visual in Microsoft Power BI
In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report. This visual uses Microsoft Bing “Natural Query Language” technology. This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.
Creating DAX Columns in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column. DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX. It’s a relatively easy way to model your data.