Dynamic table/data for a scatter chart

Question

Hi all,&nbsp;I have multiple measures created for Importance/Satisfaction with aspect of a service. I am trying to build a scatter plot with 4 quadrants (high Importance/High satisfaction, etc).&nbsp;Data looks like thisID&nbsp; &nbsp; &nbsp;Service Satisfaction A Score&nbsp; &nbsp;Service Satisfaction B&nbsp; &nbsp;Service Importance A&nbsp; &nbsp; Service Importance B&nbsp; &nbsp; &nbsp;NPS score&nbsp; NPS Categ123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;promoter124&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Passive&nbsp;&nbsp;For each individual Service aspects I have calculated the average and I want to use it in a scatter chart to show their position in relation to the average intersection point of satisfaction and Importance. I also want to be able to change the be able to show whats important for detractors, etc hence the NPS is included.&nbsp;I was thinking to create a calculated table however it wont be dynamic based on the selection in a slicer.&nbsp;&nbsp;Any help would be greatly appreciated!&nbsp;&nbsp;&nbsp;

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
It seems you may create measures to get dynamic value.Here is the article about&nbsp;scatter chart for your reference.If it is not your case,please refer to the article&nbsp;How to Get Your Question Answered Quickly&nbsp;to explain more about your question.
&nbsp;
Regards,
Cherie
&nbsp;

anonymous · Answer

HI there, not exactly what I am looking for.

Basically I want to replicate this scatter plot (see attached the Excel ) in PBI. The values will change base on different filters(reporting off a pivot table. I have created the measures (average of scores for each attribute) but now I would like to make it dynamic in PowrBi like it is in excel once i apply slicer selection.

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
You may add average line as below.Attached sample file for your reference.

Regards,

anonymous · Answer

this looks great, however my Attribute 1 AVG importance, attribute 1 AVG satisfaction,&nbsp; Attribute 2 AVG Importance, Attribute 2 AVG satisfaction etc are calculated separated measures in PowerBi. Is there a way make that dynamic in a table? In the scatter plot I cannot pull more than one field in the X/Y axis...so i have the position only for the attribute one. The two lines represents the Avergage of all&nbsp; Attributes Importance and all Attributes Satisfaction and it should change based on different other filter. So i am assuming the table should contain all fields that I want to bring in for filtering ? Looks like I will have to replicate the table in Excel with the attributes avg value for importance and satisfaction. Any idea how? Or is there a different way?&nbsp;Thanks a lot in advance&nbsp; for your help with this!

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
It seems there's no better way to put multiple different measures into scatter chart.You may try to adjust data structure&nbsp;and create one measure to get dynamic values and use it in x_axis/y-axis.
Regards,

Forum Discussion

Dynamic table/data for a scatter chart

5 Replies

Related content

Scatter Chart

Dynamic formatting shows only some data correctl in matrix table.

Dynamic scatter plot

Dynamic Column Headers in Table Visual Based on JSON Data

Scatter chart.