Forum Discussion
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...
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.
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