Forum Discussion
Solved
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 ab...
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.