Turning Off Auto-Size Column Width in Microsoft Power BI

Thanks, Fred Kaffenberger, for sharing your tip with me for the Matrix visual in Microsoft Power BI. Check out this video to see Fred’s suggestion on manually controlling the width of columns. It’s simple and cool!

Thanks, Fred Kaffenberger, for sharing your tip with me for the Matrix visual in Microsoft Power BI.

Tiny Tips

Check out this video to see Fred’s suggestion on manually controlling the width of columns.  It’s simple and cool!

 

Changing the Report Background in Microsoft Power BI

Changing the background of a report in Microsoft Power BI can, and will, change the user’s experience.  In this Tiny Tip I will show you how to make every visual stand out a little more, by just changing the background.  

Tiny Tips
by @MsBelindaAllen

Changing the background of a report in Microsoft Power BI can, and will, change the user’s experience.  In this Tiny Tip I will show you how to make every visual stand out a little more, by just changing the background.

 

 

 

Formatting the Matrix Visual Microsoft Power BI

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. 

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)

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!

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)

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!

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 this video, I’ll show you this very feature in a Clustered Column Chart.

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”

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.

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.

Continue reading “DAX 101 – Wrap up in Microsoft Power BI”

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.

 

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.

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 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!

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”