Why cant I add Outlier label to a scatter plot

[james_pease]

Hello again! So, I think I am coming to a close with highlighting outliers in my data visualizations. I have the following DAX expression:

Outlier = IF(CALCULATE([Cost %]-[Outlier STDEV]) < [Cost %] > CALCULATE([Cost %]+[Outlier STDEV] ), "Outlier")

Here are the measure used in the above formula for more context:

• Cost % = IF(sum(All_Actual_Sales[Actual Sales])>0,
  sum(All_Actual_Expenses[Amount])/sum(All_Actual_Sales[Actual Sales]))
• Cost % STDEV = STDEVX.P(All_Actual_Expenses, [Cost %])
  
• Outlier STDEV = CALCULATE(2.5* [Cost % STDEV])

What I am doing is + and - the [Outlier STDEV] measure from the [Cost %] mesaure to give parameters to the "Outliers" label I am trying to create. Please help me solve why I cant add this to my current scatter plot. I cleared out the names of the Directors for privacy, the colors reflect the directors names

[daXtreme · Accepted solution]

@james_pease 

You want to put the text "Outlier" next to each point that is an outlier according to the formula? If so, then I know only one YT vid that talks about something similar. Here it is: 100% Control of Data Labels in Power BI - YouTube

But... you have to be prepared for some advanced features, like using Tabular Editor and calculation groups. You've been warned! 🙂

[james_pease]

Thank you! Its always these type of things that require the most complicated formulas haha! I will check this video out and get back to you.