Forum Discussion
How to do conditional formatting so that it changes dynamically??
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
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:
In doing so, you are also helping me. Thank you!
MintuBaruah 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 .