Forum Discussion
barchart - measures
Hello,
I am using two measures in a bar chart for displaying values of goals orders count and completed count and in the x axis, stations values are displaying like A B C D E.....
The values in bar chart will filtered upon the some slicer selection.
My requirement is that, I would like to show only non zeroes count , if both goal and completed has 0 and 0 then those ones should not show in the chart.
But in the visual filter level , if I filter goal >0, all goal counts which are 0 are not showing but in those some of them have completed numbers and they are going off too alongwith goal and its vice versa with completed measure as well...
How do we achieve this one like exclude the stations which are both having count goal and completed 0???
Thanks
Hi Rakesh_508
You could try to create a third measure that looks something like this:Measure 3 = IF([Measure 1]=0 && [Measure 2]=0,"filter","keep")You can then add this measure as a visual level filter on your chart, and configure Show items when the value is "keep".
Let me know if this works for you.
Best regards,
Daniel
2 Replies
- dk_dkSuper User
Hi Rakesh_508
You could try to create a third measure that looks something like this:Measure 3 = IF([Measure 1]=0 && [Measure 2]=0,"filter","keep")You can then add this measure as a visual level filter on your chart, and configure Show items when the value is "keep".
Let me know if this works for you.
Best regards,
Daniel- Rakesh_508Helper I
dk_dk I did the same but instead of =0 , Im trying to use<>0.. thats why its not working for me....
Thanks, your solution worked for me....