Forum Discussion

shill1000's avatar
shill1000
Helper IV
8 years ago
Solved

Cannot see visualisation options

I'm missing something simple I'm sure, but I have a table of % values and a bar chart visual of the same. Both are suppressing 0 values, but I can;t enable the option to display 0's. I'm expecting a ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi shill1000,

     

    Please switch the summary mode of value field to 'do not summarize' to show zero values.

    In addition, above method only works on table visual. When you use bar chart, value field shows as summarized value.(if current column which in value field can't be summarized, it will show the the value as count of xxxxx)

     

    BTW, current power bi not contains features to force display zero value.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi shill1000,

 

Please switch the summary mode of value field to 'do not summarize' to show zero values.

In addition, above method only works on table visual. When you use bar chart, value field shows as summarized value.(if current column which in value field can't be summarized, it will show the the value as count of xxxxx)

 

BTW, current power bi not contains features to force display zero value.

 

Regards,

Xiaoxin Sheng

  • shill1000's avatar
    shill1000
    Helper IV
    8 years ago

    Xiaxin,

     

    Thanks, that wasn;t the actual solution but it pointed me in teh right direction. I was looking at the value summary options, and once I checked the Axis oprtions I found the show items with no data option. Doh!

     

    Simon