Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I've currently got a setup where a user selects one of 8 options using a slicer and this adjusts a linked Matrix Table dependent on the selection. The table essentially has one Measure in the value field and this is where the problem comes in:
As I've only got one measure / value field in use, this is the only field to which I can apply conditional formatting. My issue is that I want to be able to apply *specific* conditional formatting dependent on the selection from the slicer.
Code copied below - any help much appreciated.
Selected Metric = VAR MySelection = SELECTEDVALUE('Select Metric'[Measure]) Return SWITCH ( TRUE (), MySelection = "Volumes (Cumulative)",[Volume Cumulative], MySelection = "Forecast (Cumulative)",[Cumulative Forecast], MySelection = "% Forecast Met (Cumulative)", FORMAT ( [Ytd. % Forecast Met], "0.00%" ), MySelection = "Variance (Cumulative)",[Cumulative Variance], MySelection = "Volumes (by Month)",[Volumes (by Month)], MySelection = "Forecast (by Month)",[Forecast (by Month)], MySelection = "% Forecast Met (by Month)", FORMAT ( [Monthly % Forecast Met], "0.00%" ), MySelection = "Variance (by Month)",[Variance (by Month)], [Volumes (by Month)] )
Hi @david_MAS
It seems you may create a measure and use it in conditional formatting like below posts.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |