Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SamfarUK
Regular Visitor

Make line of graph go to zero

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. 

XHB7464_0-1697018444089.png

I can't figure it out and I can't seem to find a resolution either. 

1 ACCEPTED 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!! 

XHB7464_0-1697029020837.png

 

XHB7464_1-1697029047132.png

 

View solution in original post

7 REPLIES 7
mussaenda
Super User
Super User

Hi @SamfarUK ,

 

Have you tried adding +0 on your measure of line graph?

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!! 

XHB7464_0-1697029020837.png

 

XHB7464_1-1697029047132.png

 

BITomS
Resolver IV
Resolver IV

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:

XHB7464_0-1697021264068.png

(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:

XHB7464_0-1697022905468.png

Not sure if this measure works? 

Please could you share your data model? (pbix file)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors