Forum Discussion
CONDITIONAL FORMATTING WITH FIELD PARAMATERS IN MATRIX
- 2 years ago
Hi NBDOC ,
If field parameters don't work for you, I would go old school. So basically, you create a table that has the name of your measures and use a conditional formula to return the value of a measure depending on what of the value of the measure column from another table. In the image below, Measure in Columns tile is from a column from __MEASURES table which doesn't have relationship Table. What binds them is Actual Budget Diff measure.
Actual Budget Diff = SWITCH ( SELECTEDVALUE ( __MEASURES[Measure] ), "ACT", [ACT], "BUD", [BUD], "DIFF", [DIFF] )It is rather finnicky but should work in most cases. Please see attached pbix for details.
Hi danextian
This measure is part of a field parameter so conditional formatting option is not listed in the drop down list. . Where can I find the dialogue box you are referring to earlier?
Appreciate your help.
Enable Show selected field.
The option to conditionally format a parameter will appear after doing so.