Microsoft Power BI allows for the hiding of fields in Report Mode. In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.
Today’s DAX Expression:
Customer and Class = Customers[Customer Name] & " " & Customers[Customer Class]
Category: DAX
Using DAX with Conditional Formatting in Microsoft Power BI
OK, I have this table visual in my Microsoft Power BI Report and I want to highlight a row if a column value is “Yes” but do nothing to the background if the value is “No”. In this Tiny Tip video, I will show you how to achieve this very thing.
Today’s DAX Expression:
Hold Background Color =
VAR _HoldColor = SELECTEDVALUE(Customers[Hold])
RETURN
IF(_HoldColor = “Yes”, “#A0D1FF”)
Using a DAX function as a Report Title in Microsoft Power BI
Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report. In this Tiny Tip I will show you how to make a DAX measure become text for a Report Title. Because it is a visual, it will even be interactive with the remainder of the report!
DAX 101 – Wrap up in Microsoft Power BI
In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals.
Using DAX Measures across multiple Queries in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure creates the Salesperson Commission amount. To achieve this, I’ll have to multiply two fields together that reside in different queries.
Continue reading Using DAX Measures across multiple Queries in Microsoft Power BI
Using DAX Measures that Counts the number of Invoices in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure will be used to count the number of Invoices. The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears.
Continue reading Using DAX Measures that Counts the number of Invoices in Microsoft Power BI
Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI
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.
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
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
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.
Ms Belinda Allen 