Bits and pieces from the world of Business Intelligence by Belinda Allen
You cannot improve what you do not measure.
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”
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”
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”
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/
In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.
In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.
Continue reading “Line Chart Formatting 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”
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”
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.
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.
Continue reading “Adding the Q&A Visual 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.
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.
Continue reading “Creating DAX Columns in Microsoft Power BI”
