I'm using a categorical x-axis for a simple column chart. In this case, it's important for me to always show all categories - to show those categories with blank (or 0 value). The problem is that the categories without any values are hidden by default and there seems to be no easy way to prevent it from happening.
Is there a good solution for this?
Solved! Go to Solution.
A workaround I just found was to create a Measure that returns 0 if blank for the value, like this:
IF(ISBLANK(value); 0; value)
However, the same method does not seem to work for regular/calculated columns.
Please let me know if there are other ways though.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!