Forum Discussion
J_S_A
1 year agoHelper I
Conditional formatting by row
Hi all, I'm wondering if anyone could help me solving this. I have a visual table in Power BI that looks like this: All columns have been calculated, based on the main table. What I n...
andrewsommer
1 year agoSuper User
To start it looks like you are using implicit measures in your power bi table instead of explicit measures. If you make explicit measures for those fields and then put them in the values field of a matrix visual. In the formatting for the matric go to Values > Options > Switch values to rows.
Then you should be able to click on each measure in the Values box of your visualization to add conditional formatting to that field.
Please mark this post as solution if it helps you. Appreciate Kudos.
- J_S_A1 year agoHelper I
Hi.
Thanks for advising to turn the measures into explicit ones. I've done it, but unfortunately I don't want the table to look like the matrix you have proposed. I want it to look like as I have attached.
Thanks anyway!