Forum Discussion
Post ProdigyZero Values not showing for the Bar chart
Hi Team
I am facing an Issue in Bar charts with zero values. We have an Incident data for December 17 to May 31, where we are extracing from the remedy. After building all barcharts, i have a strange issue in some of the months data is missing due to no data populated for this. For that missing data in the bar charts i want zero to populated. I tried adding all the respective measure & Columns by "+0" and in Axis right click - show items with no data & the formula IF(Column=blank(),0,Column), this are affecting the other columns & Measures. Is this bug or known error. Please help. Attached is the Screen shot for your reference.I want to show Zero values for the No data region
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.
2 Replies
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
prakash11440278Hi 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.
