Forum Discussion
How to do conditional formatting so that it changes dynamically??
Hi community!!
I have been given data and from which I have made a table in which there is a column name Average salary and I am having slicer of dates. I want to have a green color if values are above their column's net average and have to be red if they are below net average.
Problem is net average will have to change dynamically and so as colors relatively.How can I do the same???
Thanks in Advance
pmusram , Assume you have measure [Avg Salary]
Avg Salary overall = averageX(allselected(Table),[Avg Salary])
create a measure like
Color = Switch(True() ,
[Avg Salary] >=[Avg Salary overall] , "Green",
"Red"
)
Use this measure in conditional formatting with field value option
refer for steps
https://www.youtube.com/watch?v=RqBb5eBf_I4
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
4 Replies
Hello pmusram
I tried this by taking an example of years and Average Salary.
Screenshot 1:
Screenshot 1 shows the Values after conditional formatting.
For condition formatting Navigate to Format-> Data Colors-> click on fx
Then apply the below changes(refer to screenshot 2), I took 100000 as the net average
Screenshot 2:
Regards,And if you find the solution useful please mark my post as a solution!
In doing so, you are also helping me. Thank you!Mintu BaruahMintuBaruah Thanks for helping me out.Your solution has helped me but not answered my question as I need to conditional formatting. As my data will change it has to vary accordingly.You can see amitchandak his answer once .
pmusram , Assume you have measure [Avg Salary]
Avg Salary overall = averageX(allselected(Table),[Avg Salary])
create a measure like
Color = Switch(True() ,
[Avg Salary] >=[Avg Salary overall] , "Green",
"Red"
)
Use this measure in conditional formatting with field value option
refer for steps
https://www.youtube.com/watch?v=RqBb5eBf_I4
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
amitchandak Thanks for helping me once again. Solution Worked for me.
