Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Strange behaviour between slicer and visual

Hi,   I have a slicer based on a field parameter containing measures. And I have a line and stacked column chart. When selecting everything the colors in legend and visual match     When...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I did ChiragGarg2512  but doesn't help

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Anonymous , I checked and this happens in the case of field parameters. What can be done is create a measure for conditional formatting of line and stacked column chart.

     

    Create a dax using switch:

    Measure 4 = SWITCH(SELECTEDVALUE(f1[f1 Order]),0, "#118DFF", 1, "#11239E" , 2, "#")
     
     
    f1 is the field parameter. f1 order gives 0,1,2 respectively for whatever field parameter it holds. Then apply a switch statement that changes on the basis of order value. you can either put the color name or the hex code of the color. 
     
    Now select a field parameter and go to column field in format visual of line and stack column chart. There is an option fx for conditional formatting. Change to field and add the measure. This should fix your problem.
     
    Thank You