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.

     

Anonymous's avatar
Anonymous
Not applicable
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.