Forum Discussion
Advocate ISurpress Zero values in Charts
Community ChampionRomeshpsl for fields dropped onto visual you also have option to specify show items with no data which will take away blanks.
RomeshpslThanks 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.
deepvibhaAdvocate II
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?
This solution works if the field is taken as is.
However if the filter or the data values is a measure/calculated field , this method does not work.
Lets say instead of "fte", had it been Avegrage fte then it will take that calculated measure and if you try to filter it with "greater then 0" it will give incorrect results.
The intent is to get the supressed values as input at first place and then doing average of that.
Is there a solution for that?
One can always write if-else DAX query but I am looking for a less complex solution.
We can apply filters to the values if they are not measures or calculated fields.
However , in the same example had there been "Average fte" instead of just "fte" this method wont work or will give incorrect results.
One can always write DAX if-else queries to get results as desired but I am looking for a less complex solution.
