WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
How to show rows with no corresponding data in a Power BI visual
This modest blog explains how you can tell Power BI to show all of the members of a dimension table (even the ones which have no corresponding data).

Posted by Andy Brown on 12 March 2020

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Choosing to show blank rows in a Power BI visual

This is a short blog, written (I confess) just to remind me of something I always forget - how to show dimension rows for which there is no corresponding data:

Missing data

I've got 9 regions in my underlying model, but only 3 of them have sales in. How to show the missing 6 regions?

 

The answer is to click on the drop arrow next to the RegionName field (not the quantity field) in the field well:

Show items with no data

Choose to Show items with no data for each region.

 

Problem solved!

Missing data visible

You can now see all of the regions - even those for which there were no corresponding sales.

 

Hopefully I'll now remember this next time somebody asks me!

This blog has 0 threads Add post