Forum Discussion
Mants
1 year agoFrequent Visitor
Conditional formatting background in table based on measure / calculated column
Dear, I'm creating a table which will have between 30-60 columns and around 25 rows. I would like the background of each cell to be colored based on specific rules (i.e. larger than x and smalle...
lucadelicio
1 year agoImpactful Individual
Hi Mants probably you have to start to review your dataset because in your power bi you have 1.020 rows instead of 25 you said.
Create and import the correct dataset then re-publish the pbix to get the help that you need.
Thank you
Mants
1 year agoFrequent Visitor
Hi Luca, yes that correct thanks for checking.
The end result of that table would be a table visual where Order would be pivoted to columsn (1 to 30).
Then in that table each cell needs to be formatted, with the challenge presented above.
For the purpose of illustration the end result table visual is created with columns 1 to 11