Forum Discussion
o59393
2 years agoPost Prodigy
How to hide empty values from a column chart
Hi all
I have 3 columns in a chart and one of them has a value of zero for a given year. I´d like to know if it´s possible to get rid of this column since it´s taking unnecesary space:
I tried using null instead of zero and the chart would just show an empty space, which is precisely what I´d like to have removed.
Is this possible?
I tried this measure:
Unit_Cases_BP =
var _bp =
SUM(Query1[[Unit_Cases_BP]]])
Return
IF(_bp=0,BLANK(),_bp)
Thanks.
1 Reply
- amitchandakSuper User
o59393 , Create a calculation group and try to use the calculation group name as the second axis and expand and try
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0