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
Category: 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.
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.
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. https://maqsoftware.com/
Line Chart Formatting in Microsoft Power BI
In this video, I demonstrate formatting the Microsoft Power BI Line Chart visual.
Continue reading 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.
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.
Continue reading Adding the Fields to a Visual’s Tooltips in Microsoft Power BI
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.
Continue reading Adding the Q&A Visual in Microsoft Power BI
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.
Not Your Daddy’s Financial Series
I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series. Feel free to join me!
Ms Belinda Allen 