Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)