Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |