Forum Discussion
Is there any possible method to do conditional formatting on column when comparing multiple values?
Hi,
I have a table in Power BI and my requirement is that I want to add conditional formatting on on of its column based on the values of other column.
So, suppose in my case as seen in the image below, I want to color the background of cells of column Growth 2018 by comparing its values from column Growth 2017. So, if value in Growth 2018 > Growth 2017 then the color should be Green else Red.
So, is it by possible by any means I can achieve this type of formatting on column?
P.S. - I have already tried creating a new calculated column which consists of the difference of these columns and applied formatting on that column based on the values. But my requirement is I need to do formatting on the same column values by comparing it to another metric.
Thanks!
4 Replies
The solutions i've had to use for similar circumstances has been to create a measure which uses the context of the row to calculate my conditional groupings. I have my measure return values like 0, 1, 2, 3, .. etc. I then load this measure in as a column in the table and place the conditional formatting of both background and font onto this measure. Its not ideal, as i'd normally perfer to have my formatting on the actual numbers, but until thats implemented this is a workable method.
Thanks for your reply, I have used the method you have suggested earlier but I was also looking for a way to implement the formatting on the actual numbers if that is possible in Power BI.
