Forum Discussion
Row Conditional formatting on text in a Matrix visual
- 6 years ago
Hi sperry ,
You can try to create the following measure:
Measure = VAR __q = SELECTEDVALUE ( 'Table'[Q1 Project Status] ) RETURN SWITCH ( TRUE (), __q = "Not Started", 1, __q = "On Track", 2, __q = "Minor Delay", 3, __q = "Completed", 4 )Right-click on the 'Values' field in Matrix - Conditional formatting - Background color - Format by Rules - Based on Measure, and then customize the format of the condition you want, as shown below:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi sperry ,
You can try to create the following measure:
Measure =
VAR __q =
SELECTEDVALUE ( 'Table'[Q1 Project Status] )
RETURN
SWITCH (
TRUE (),
__q = "Not Started", 1,
__q = "On Track", 2,
__q = "Minor Delay", 3,
__q = "Completed", 4
)Right-click on the 'Values' field in Matrix - Conditional formatting - Background color - Format by Rules - Based on Measure, and then customize the format of the condition you want, as shown below:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Worked like a charm..perfect..Thanks for your time..This forum is the bomb!