Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago

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

  • 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