Forum Discussion
Line and stacked column color based on multiple conditional formating
Hello guys , hope you`re doing great today. What i`ve tried these days but withount any solution so far , so here`s my question : DO you think that seeing the graph above i have two targets , so i woul want to see for example in the graph all of the columns that are below first target to be green even the one with yellow and red , then between these two graphs to be yellow including the red one and finally above the 2nd target to be red .
So something like this , so the first two column to have actually 3 colors : green until 1st target , yellow between 1st and 2nd target and red which will be everything out of the 2nd target .
Thank you so much for reading this and maybe i could find some positive answers . Have a nice day!
1 Reply
You can do this using conditional formatting based on a measure. You can check this explanation: https://xyloslearning.com/en/power-bi-using-a-measure-to-set-up-conditional-formatting/
If you have any doubts afterwards you can reach out!
