Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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:
@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 .
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |