WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 8944 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

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