Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All
Maybe this is a newbie question but I cannot find the answer anywhere.
We have this chart with the items sold by region, grouped by quarters
How can I remove the quarters with no sales from the chart? So 2019 & 2020 would only have 1 column.
Thanks!!!
Solved! Go to Solution.
Hi , @GabrielDC
I didn't find a way to hide y-axis = BLANK() in small multiplots, for small multiplots, he is mainly used to clone grouped data showing different categories.And there are limitations for this function:
For more information, you can refer to :
Create small multiples in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @GabrielDC
I didn't find a way to hide y-axis = BLANK() in small multiplots, for small multiplots, he is mainly used to clone grouped data showing different categories.And there are limitations for this function:
For more information, you can refer to :
Create small multiples in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Have you enabled "Show items with no data" in the field (down arrow in the field well)? Toggle this off to suppress items with no data.
Is it possible that your data contains offsetting amounts such that the result is 0 or fractional cents? If so, you may need to modify your measure to return blank if the amount is 0 or rounds to 0.
Proud to be a Super User!
Thanks for your asnwer. I tried that but does not make any difference:
The Y-axis is a record Count field, no decimal impact there.
We would like the same way we get in in Domo:
In your screenshot, "Show items with no data" is enabled (checked). You need to toggle this option off in order to suppress items with no data.
Proud to be a Super User!
Are you using Small Multiples? This may be the default behavior (not sure if it can be overridden).
You can try adding Year to the hierarchy in the X-axis and expand (drill) down to the Quarter level:
Proud to be a Super User!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
67 | |
65 | |
57 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |