Forum Discussion
Zero Values not showing for the Bar chart
- 8 years ago
Hi v-shex-msft,
Thanks for your reply.
In my scenario i have 4 date columns(Closed Date, Resolved Date, Arrival Date..etc), all columns are pointing to different visualization, due to these it is not possible to create calander table and link to original table. "+0" is working fine for those bar charts who doesnot added as legend. But in my case i have added priority as legend, due to this field i am not able to show 0 values in my visualizations. Attaching the Issue Screen shot, which zero values are not showing.
HI prakash11440278,
If your table not contains these records, it is impossible to direct displya these missed records.
Please create a calenar table and link to original table, then you can use calendar date as axis and use measure with '+0' to expand blank records.
Notice: 0 and blank value not display on chart, please use table to see detail effect.
Regard,
Xiaoxin Sheng
Hi v-shex-msft,
Thanks for your reply.
In my scenario i have 4 date columns(Closed Date, Resolved Date, Arrival Date..etc), all columns are pointing to different visualization, due to these it is not possible to create calander table and link to original table. "+0" is working fine for those bar charts who doesnot added as legend. But in my case i have added priority as legend, due to this field i am not able to show 0 values in my visualizations. Attaching the Issue Screen shot, which zero values are not showing.