Forum Discussion
Color Items Above Average Line
SC30GSWNBA
You can conditionally format the marker colors in scatter plot
Conditional formatting window:
if you keep the thresholds dyanmic then you can create a sonditional formatting measure and apply the same.
If I understnad correctly then I think your baseline_percentage measure is incorrect. You can use this pattern
Baseline_Percentage =
Var __Sales = sum('Baseline_data'[Sales])
Var __TotalSales = calculate(sum('Baseline_data'[Sales]), removefilters('Baseline_data'[Employee]))
Var __OverHead = sum('Baseline_data'[Overhead]
Var Result = Divide(sum('Baseline_data'[Sales]), __TotalSales) + __OverHead
return Result
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you for the solution tharunkumarRTK, but no the Baseline calculation is correct and I do not want to change my view for scatter plot. It should strictly be Baseline Percentage vs Sales. I want to show the employees who are below baseline percentage.
