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

Hi ChiragGarg2512  I implemented your solution, but still there is a mismatch when I only choose one selection from the slicer

ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

Anonymous , Share image because that is what the measure is supposed to avoid. The measure makes it such that whenever let's say real customer was selected it is paired with grey color, which was it's color preslicer selection.

 

In this case field parameter order, 

0-> Recovered

1-> Reimbursed

2-> Real Customer

 

If possible share a Dropbox link to pbix file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    ChiragGarg2512  pbix file is pointing to a shared dataset. I can't send you the dataset

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Solution Sage
      2 years ago

      Send image and measure formula.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    ChiragGarg2512 

    FP Color = SWITCH(SELECTEDVALUE(FP_Amounts[FP_Amounts Order]),0, "#000099", 1, "#FD6400" , 2, "#b3b3b3")
     
    FP_Amounts = {
        ("Recovered", NAMEOF('Key Measures'[Amount Recovered]), 0),
        ("Reimbursed", NAMEOF('Key Measures'[Amount Reimbursed]), 1),
        ("Real Customer Damage", NAMEOF('Key Measures'[Amount Real Customer Damage]), 2)
    }
     
    In this image real should be grey, but Legend says blue

     
    In this image it shows twice blue. recovered should be blue and Real grey
     
    Real should be grey, Reimbursed Orange, Recovered Blue
     
     
    It constantly changes