Conditional Formatting on MySelection Measure

[david_MAS]

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)]
)

[v-cherch-msft]

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.

https://community.powerbi.com/t5/Desktop/Table-visual-conditional-formatting-to-set-background-color...

https://community.powerbi.com/t5/Desktop/How-to-apply-conditional-formatting-only-for-specific-Categ...

Regards,

Cherie