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.

Thanks guys. I tried the "show item with no data" but didn't work. I think it is because there are data but the amount is zero. So did bit of search and found another solution (similar to creating a measure, but without creating one) by applying a filter to show valvue greater than 0. See below.

Create a new measure something like below , add it to your chart Measure = CALCULATE(SUM(Table1[Value]),Table1[Value]>0)

Romeshpsl for fields dropped onto visual you also have option to specify show items with no data which will take away blanks.

Romeshpsl you can change the position of the data label to Inside End. Simple but effective.

I had the same problem and just replaced the 0 values with null in the power query. It works for me!

Surpress Zero values in Charts | Microsoft Fabric Community

12 Replies

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
  Helper 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.
ankitpatira
Community Champion
10 years ago
Romeshpsl for fields dropped onto visual you also have option to specify show items with no data which will take away blanks.
- Romeshpsl
  Advocate I
  10 years ago
  Thanks guys. I tried the "show item with no data" but didn't work. I think it is because there are data but the amount is zero. So did bit of search and found another solution (similar to creating a measure, but without creating one) by applying a filter to show valvue greater than 0. See below.
  - deepvibha
    Advocate II
    9 years ago
    I am plotting a clustered column charts for various surgeries performed by a group of doctors for a particular day.
    
    Its not mandatory that all the doctors will perform all types of surgeries in a day.
    
    If I apply filters to suppress Zero values on all types of surgeries, the chart goes blank.
    
    How do i achieve it?
Justair07
Resolver I
6 years ago
Romeshpsl you can change the position of the data label to Inside End. Simple but effective.
- Anonymous
  Not applicable
  3 years ago
  GREAT SOLUTION
Anonymous
Not applicable
6 years ago
I had the same problem and just replaced the 0 values with null in the power query. It works for me!
- Werbenmanjensen
  Frequent Visitor
  3 years ago
  This was the perfect solution! Thank you!
Anonymous
Not applicable
5 years ago
Hi everyone,
I have the same issue with the matrix chart. I created a measure to calculate, so on the chart showing zero value. I want to suppress zero value (red color box below)
Thank you!