Forum Discussion
Conditional formating based on a dynamic table
I created a dynamic table to use the option of a conditional formating over a matrix table….
In Excel is so easy (Excel is a crap) but here in PBI I have to do it over every column (which are measures %M1, %M2, %M3 and so on)
The idea is that the conditional formating considers the low number of my table the best (green)
anybody could give me a hand with some idea link where I could learn?
PBIX sample: https://www.dropbox.com/s/f724xn7fwm711lc/AGING.pbix?dl=0
Really appreciate any help!!!!!!
My dinamic Table:
My desired result is what I have in excel:
11 Replies
Anonymous , you should color scale with diverging option
It doesnt work...everything is red or everything is green...why...I cant not see what am I doing wrong...can you give me a hand? amitchandak
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description, I think you can use ‘format by rules’ to display.
Like this:
Here is my sample file for you. Hope it helps.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank for helping me out
But I need to paint according to the dynamic table.
Any idea?
Hi, Anonymous
Can you show the desired result about the dynamic table, I'm not sure what you really need.
Best Regards
Janey Guo
