Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team
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.
Hi Aishwar04
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.
Maria
Hi @MariaP
Thanks for your response!
Yes, this is what I need to show 0 upon slicing instead of the visual going completely blank.
Hi Maria
Not able to download the file.
Could you please send the DAX here.
Hi again,
Create these 2 measures.
Use Model as your filter and for you Axis
Use Display Total in your Value for your bar graph.
Total Model = SUM('Sample'[Count])
Display Total = If(ISBLANK([Total Model]),0, [Total Model])
Cheers,
Re-created link also included.
I have accessed OK. Not sure why this does not work .
https://www.dropbox.com/s/ql3wuq7a1jz9tla/Aishwar04.pbix?dl=0
Stating the obvious, but this is what I see when I try to download....
Hi,
Yes, the Matrix visual which I have used, when converted to a graph, "Measure" will show 0 wherever there are blanks
Hi Team
Anyone with an idea for this issue.
Hi @Anonymous,
You can use the below DAX Statement
Measure1 = IF(ISBLANK(Measure),0, Measure)
Hi Thejeswar
I have already used this in DAX but the visuals still go blank upon slicing.
Hi @Anonymous,
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |