topic Re: Color Items Above Average Line in DAX Commands and Tips

Color Items Above Average Line

SC30GSWNBA — Sun, 23 Jun 2024 12:27:58 GMT

Hello All,

I need some help with respect to a Scatter Plot. I have got a dataset as follows -

Date	Employee	Sales	Overhead
06/21/2024	E1	25	25
06/21/2024	E2	25	25
06/21/2024	E3	10	20
06/22/2024	E1	25	25
06/22/2024	E2	25	25
06/22/2024	E3	20	10
06/23/2024	E1	20	30
06/23/2024	E2	30	40
06/23/2024	E3	20	50

I have created a Baseline Percentage Measure as follows -

Baseline_Percentage = SUM('Baseline Data'[Sales])/(SUM('Baseline Data'[Sales])+SUm('Baseline Data'[Overhead]))

Based on Baseline_Percentage I have been able to create a scatter plot as follows -

Baseline percentage on Y axis and Sum of Sales on X axis.

I now need to show the items above Baseline Average i.e 44.4% across three days as separate color and items below baseline average as separate color but not able to do so. Could you please help me solve the issue ? Also I need to ensure that the chart works perfectly fine based on date slicer selection shown below -

Re: Color Items Above Average Line

tharunkumarRTK — Sun, 23 Jun 2024 13:37:08 GMT

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

Re: Color Items Above Average Line

SC30GSWNBA — Sun, 23 Jun 2024 16:23:43 GMT

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.