Using an Inserted Shape as a Navigation option in Microsoft Power BI

In this Tiny Tip, Belinda will show you how to use a new feature to do something cool, using Microsoft Power BI: Page Navigation using an inserted shape.

In this Tiny Tip, Belinda will show you how to use a new feature to do something cool, using Microsoft Power BI.

In this report, there is a page that is Sales by category, with a slicer that displays countries.  There is a similar page, that displays a table with sales line details.  The slicer on the detail page is sync’d with the first page.

Belinda will Insert > Shape, selecting a triangle.  The April 2021 update has many more shape options.  Another great option for this example, opposed to the Triangle, would have been right arrow or the chevron.

Belinda will format the triangle and add an Action to the shape, on the Format shape pane.  The action assigned will be Page Navigation, then select the detailed page. 

Now, with a simple click in the web service (or a Ctrl+click in the desktop), users can easily navigate from one page to the next.

Creating a Template Page for Consistency in Microsoft Power BI

One of the first things I do when I start creating a Microsoft Power BI report is create a template page, which I call Blank. When creating a (new) page, I just duplicate the template/blank page and start building. This helps provide a consistent look for all my pages.

One of the first things I do when I start creating a Microsoft Power BI report is create a template page, which I call Blank.  When creating a (new) page, I just duplicate the template/blank page and start building.  This helps provide a consistent look for all my pages.

By Ms Belinda Allen

Displaying Images in the Data using Microsoft Power BI

I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC). In this video, I will show you have I get team logos from my dataset to display.

I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC).  In this video, I will show you have I get team logos from my dataset to display.

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.

Tiny Tips

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!

Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report.  Tiny Tips 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!

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

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”

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”