I have a bar chart and upon selecting certain values values in slicer it goes blank. I have used the ISBLANK() in the measure that is being used in the bar chart. Is there a way to show like "Data not available" or 0 in such cases. Quick help will be appreciated.
Is this what you are trying to achieve? If so, I will post quick solution.
Please post your desired outcome and some data to help answer your question.
When I select Mazda, Visual remains with zero data as the result.
I tried replicating your scenario. But I am not able to replicate it
Here is my screenshot in two cases
1. When the data is not sliced
2. When the data is sliced
In the above 2 cases, Measure and Measure2 column values are unchanged.
Here the Measure column is the one where the Blank is handled using the below DAX statement
Measure = IF(ISBLANK(SUM('Merge Table'[Quantity])),0, SUM('Merge Table'[Quantity]))
The Measure2 is without BLANKs handled
Measure 2 = SUM('Merge Table'[Quantity])
In both the cases, the data looks fine.