Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |