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 everyone! First time poster here 🙂
I really need help with this column/line graph please? I want the line y-axis to actually go down to 0.00% rather than just disappear.
I can't figure it out and I can't seem to find a resolution either.
Solved! Go to Solution.
I was about to ask you where/how I would add this but thought I would give it a go myself...
I have now added that +0 to the end of the measure and it has worked perfectly, thank you!!
I was about to ask you where/how I would add this but thought I would give it a go myself...
I have now added that +0 to the end of the measure and it has worked perfectly, thank you!!
Hi @SamfarUK
This might help you: https://stackoverflow.com/questions/55495656/show-0-value-on-line-chart-in-power-bi-for-missing-data....
It looks like you need to force the use of a zero in your measure.
Thanks for your response!
I did see multiple times online about changing the type, but I genuinely can't see where to do this; these are my options:
(FYI - I am using the Power BI Desktop on my laptop)
I think the part about how to express a measure is more pertinent:
Measure = IF(ISBLANK([MeasureName]),0,[MeasureName])
Do I need to add the measure somewhere specific?
Also, the dataset doesn't have any blanks and is not showing null:
Not sure if this measure works?
Please could you share your data model? (pbix file)
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |