This content has been marked as final. Show 2 replies
I'm using a stacked bar chart with 1 dimension and 2 measure. Year Dimension , Missed time and Non Missed time Measures where the 2 measures has filter to show only for 2017 data but the dimension values for year has 2015,2016,2017
In dimension to exclude the values for 2015,2016 I'm using limitation Fixed value(TOP 1) so that the data will be shown only for 2017.
If there is data in Missed time measure then it's showing the data for Non missed time also in the graph which is common. but if there is no data in Missed time i.e say it has 0 the second measure i.e Non missed time is not showing up in the graph regardless of having the values for it.
When i apply limitation i see that it displays a message showing that it is applied only for Missed Time Measure which is the first measure in the graph and that is the reason the Non missed time datas are not shown when the Missed time measure does not have data since it is taking top 1.
When i convert this to Pivot table i dont see any such Issue. Can any one let me know why this is happening?