Dynamic x and y axis scatter plot data model

[mrrob]

Hi,

I would like to build scatter plot where user can change x and y measures from some kind of slicer. My data looks like that

Param1	Param2	Param3	Param4	Param5	Param6	Param7
1	3	5	7	9	10	12
2	4	6	8	0	11	13

My go to chart will be scatter with 2 slicers: one with list of all params (Param1-Param7) which controls x axis and second also with (Param1-Param7) which controls y axis. 

I already done this but it required pivot and crossjoin table itself what causes performance issues. Do you know any way to model data to acheive n computational complexity instead of n^2 (remove crossjoin somehow)? 

[ribisht17 · Accepted solution]

@mrrob 

See if it helps https://community.powerbi.com/t5/Desktop/Scatter-plot-chart-X-and-Y-axis-dynamic/td-p/2717151

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[mrrob]

Thank you for your answer. However I don't know how to apply it to my case. Maybe I'm missing the point. Could you please copy my dummy table from above to PowerBI and create pbix file with it? I will be really grateful.