Forum Discussion
Calculated column from selected value
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
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
15 Replies
Anonymous If you want a formula that changes dynamically with the selection in slicer, you need to use a measure.
BBF
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_78Anonymous
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