Formatting the Matrix Visual Microsoft Power BI

Tiny Tips I love using PivotTables in Microsoft Excel.  When I use them, I always change them to Tabular and remove Subtotals to make them easier to read.  The Matrix visual in Microsoft Power BI is like the Excel PivotTable.  In this Tiny Tip video, I will show you how to make it tabular and remove subtotals.

by @MsBelindaAllen

Adding the Last Refresh Date in Microsoft Power BI (Tiny Tip)

Tiny Tips
by @MsBelindaAllen

 

In this TINY Video, I will add the last date and time the data in Microsoft Power BI was refreshed.  Old data is bad data!  This is an easy way to make sure you are looking at a good data!

Adding multiple Trend Lines in Microsoft Power BI (Tiny Tip)

Tiny Tips
by @MsBelindaAllen

In this TINY Video, I will add a trend line to my clustered column chart visual in Microsoft Power BI.  Since my visual has 3 columns in each cluster (Legend), I want to have 3 separate trend lines so I can compare the trends of each value in the legend using the same x and y axis.  This 2-minute video shows how to do this!

Underlying data in Microsoft Power BI Visuals

Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset in Microsoft Power BI.  In this video, I’ll show you this very feature in a Clustered Column Chart.

Continue reading Underlying data in Microsoft Power BI 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

Making Tooltips easier to read in Microsoft Power BI

In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes.  The default of white letters on a black background can be difficult to read.  This 2-minute video will show you simple changes that make tooltips more powerful!

Continue reading Making Tooltips easier to read in Microsoft Power BI