Forum Discussion
CONDITIONAL FORMATTING WITH FIELD PARAMATERS IN MATRIX
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.
tHello danextian
Two issues with that:
1- When selecting "Show Selected Fields", the first option "Do not Summarize" is absent on my screen. The selection defaults to "First" which would just show the name of the selected field accross the whole matrix table. As soon as I change it back to "Show Values of Selected Field", the values of that field comes back to the table but not the CF
2- The subtotal field which is calculated by the measure I posted earlier does not seem to change color no matter what. Is there a way to do that?
Thank you for taking the time and effort to help out
Super UserHi 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.