I have a bar graph with dimension- year(2009,200,2011,2012)
And
Measure----Sales(Sum) as shown in below picture
I want o create bar graph for 2009
2010
2011
2012 separately
How can we do this?
I tried this by using expression in Measure----
Sum({$<Year={2009}>}Sales)
It's working fine if I selected Single color in color
But If I'm selecting color by dimension
then on the x-axis it's showing all the year along with 2009 but i want to display only one year on the x -axis