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.

     

POSPOS's avatar
POSPOS
Post Partisan
1 year ago

meghansh  - Try if this will resolve your issue:

 

Step 1 : This is my data

 

Step 2: Plot the data in a bar chart. By default data with null values will not show up.

 

Step 3: Enable "Show items with no data" to show data with 0 values.

 

 

Step 5 : Change the formatting options:

 

 

Hope this helps.

l

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi meghansh 
    That's just how the label behaves. There's just not enough space for the label to fit inside the column. I've looked into some custom viz but they still behave the same.