Calculated column from selected value

[Anonymous]

HI Team,

I'm facing an issue like, i'm want to create a column based on threshold value and placed in Scatted chart based on their values.

Profit_Threshold value: i'm using generateseries function to get this.
Sales_threshold value:-  i'm using generateseries function to get this.
Sales_Value: - Sum(sales).
Profit_Value:- Sum(Profit)
 I have created calculated column like this,

Quadrant_Column:-  if(Sales_value > SelectedValue(Sales_Threshold Value) && Profit_Value > SelectedValue(Profit_Threshold Value), "Top Performers", if(Sales_value < SelectedValue(Sales_Threshold Value) && Profit_Value < SelectedValue(Profit_Threshold Value), "Under Performers","Average Performer")))

Above calculated column is not working.

 Using in Scatted Chart.

Could you please help me to get  this.

Regards,
Prasad_78

[BeaBF]

@Anonymous If you want a formula that changes dynamically with the selection in slicer, you need to use a measure.

BBF

[Anonymous]

@BeaBF  Thank you. But that created one we are using as  legend so that's why we are creating a column instead of Measure.

Regards,
Prasad_78

[BeaBF · Accepted solution]

@Anonymous 

Yes, you can only use a column in the legends field, so a measure will not work.

Maybe having a dis-jointed table with your possible measure results might work, can you share the pbix? to make some tests. It's too difficult to reproduce your case.

BBF

[Anonymous]

@BeaBF  I didn't see any option to upload pbix file. 
Here is the sample data for my requirement.
CustomerSalesRevenueLegends

Customer	Sales	Revenue
AB	12	54
BC	21	64
CD	31	74
DE	41	23
EF	51	11

Legends = if(Sum('Table'[Sales])> SELECTEDVALUE(Sales[Sales]) && Sum('Table'[Revenue])> SELECTEDVALUE(Revenue[Revenue]),"Top",if(Sum('Table'[Sales])< SELECTEDVALUE(Sales[Sales]) && Sum('Table'[Revenue])< SELECTEDVALUE(Revenue[Revenue]),"Below","Average"))

[BeaBF]

@Anonymous ok, and how is construct your visual? X axis, Y axis, ecc.
Also, Revenue and Sales tables are the distinct of fields in the Table table? I'm recreating your scenario.

Thx,

BBF

[Anonymous]

@BeaBF In Scater chart, 
In values :- Customer
X-axis :-  Sales
Y-Axis:-  Revenue
Size:- Revenue

Legends:- Calculated_Column.

[BeaBF]

@Anonymous I't's working for me....

In the graph are you using only fields from the Table table, correct? 

BBF

[Anonymous]

Yeah.  but in slicer i'm using numeric parameter range.

[BeaBF]

@Anonymous to me it's still working with parameters... i need to see your file to understand the problem

[BeaBF]

@Anonymous I think this is the issue... can you shere the pbix?

BBF

[Anonymous]

@BeaBF  I didn't see any option to upload pbix fil here.

[BeaBF]

@Anonymous  you can upload the file in drive and then paste the link

[Anonymous]

@BeaBF Please find the belwo link

Fields we are using in scatter chart,

In values :- Customer
X-axis :-  Sales
Y-Axis:-  Revenue
Size:- Revenue

Legends:- Which are calculating the legends column.

Link:- File

Regards,
Prasad_78

[Anonymous]

@BeaBF Do you have any update.

[BeaBF]

@Anonymous Hi,

Sorry, my response must not have posted. I've tried countless times, but to dynamically change the legend, you must use a measure, which isn't accepted by the Scatter plot. Therefore, there is no solution.

As a workaround, you can use bookmarks to switch from one chart to another with different legends, but this won't fully achieve the desired functionality. I'm sorry for the bad news.

BBF