Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 only selecting one slicer option, the colours constantly mix. Beneath you see Real Customer is grey in the legend but range in the column
Selecting from slicer one by one and then selecting the correct color won't help. Afterwards it will again mix up
What is happening here and how to fix?
regards
Ron
Hi @ChiragGarg2512 I implemented your solution, but still there is a mismatch when I only choose one selection from the slicer
@PowerRon , 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.
@ChiragGarg2512 pbix file is pointing to a shared dataset. I can't send you the dataset
Send image and measure formula.
@PowerRon , 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:
@PowerRon , Try going to column in format visual and fix them to a particular color.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |