Forum Discussion
Dynamic x and y axis scatter plot data model
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)?
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
2 Replies
- ribisht17Super User
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- mrrobFrequent Visitor
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.