3 Replies Latest reply: May 8, 2018 8:18 AM by Shweta Sarda RSS

    Master dimension - Can we use set analysis?

    Shweta Sarda

      @Hi, !


      I am using line chart with two dimensions and one measure for rolling 13 months analysis. My chart works properly for displaying values but the color disappears when I choose the AsOfDate.Month filter.


      Details about chart,


      First dimension is :

      if([AsOfDate.MonthIndex]<= $(=Max("AsOfDate.MonthIndex"))and [AsOfDate.MonthIndex]>= $(=Max("AsOfDate.MonthIndex")-12),[AsOfDate.Month])


      Second dimension is: Master dimension Risk Rating where I have assigned colors for each Risk Rating.


      Measure: sum({<[AsOfDate.Month]=> } Exposure )  


      This gives me

      Last 13 months trending with proper values and colors. As soon as I select AsOfDate.Month filter, chart gives proper values but the color disappears.


      (This works properly if I use color by expression feature. But problem with this is No Legend display. So I want to use master dimension)


      So,I want to define master dimension as Risk rating with {<[AsOfDate.Month]=> } set analysis. I also want to use value colors feature for assigning colors to Risk rating.


      How can do this?

      Thanks in advance,