More Matrix (visual) formatting in Microsoft Power BI

The Microsoft Power BI Matrix visual has more features waiting to be unlocked with formatting.  In this Tiny tip, I will show you some of my preferred formatting options.  Specifically, I will show:

  • Changing the Text size
  • Changing the alignment of a column
  • Conditional formatting for a column of values
  • Changing the values to display as rows rather than columns.

The last feature can be a real space saver when you have a lot of data, and it can allow you to have a larger font for easier reading without the need to scroll.

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.

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.

Using DAX with Conditional Formatting in Microsoft Power BI

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”)