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.
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.
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.
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. https://maqsoftware.com/
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.
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.
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.
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.
Ms Belinda Allen 