Forum Discussion

meghansh's avatar
meghansh
Frequent Visitor
1 year ago
Solved

Showing Label when value is 0

I have a bar graph with one value as 0. As I change the label orientation to "vertical" and position to "inside" the label with value "0" disappears because of having no bar to represent data. I stil...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi meghansh ,

     

    Maybe you can try formula like below, then use it to column value:

    DisplayValue = 
IF(
    MAX('Table'[Value])= BLANK(),
    0,
    MAX('Table'[Value])
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

meghansh 

Unfortunately, Power BI hides labels for zero values when there's no visible bar.

Make sure that your bars are still showing even when the value is 0. If bars are completely hidden for 0 values, try adding a small minimum value (like 0.001) in the data preparation step to create a visible bar for the zero value.

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn