Forum Discussion

Romeshpsl's avatar
Romeshpsl
Icon for Advocate I rankAdvocate I
10 years ago

Surpress Zero values in Charts

  How do I get the x axis lables disapprear from the chart when values are zero. I can't really filter out when loading data, as these lables are from a calculated column.    
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Create a new measure something like below , add it to your chart 

Measure = CALCULATE(SUM(Table1[Value]),Table1[Value]>0)

  • feelie75's avatar
    feelie75
    Icon for Helper I rankHelper I
    3 years ago

    This worked perfect, thank you!! I'd like to add a word of caution though, I had to change the > to <> otherwise it bypassed negative values on a few months where we had negative sales due to Returns.