Single scatter chart w/ dynamic XY axis

Question

Hello,&nbsp;I wanted to ask if there is way to have one single scatter chart w/ dynamic XY axis selection. Please see below:&nbsp;&nbsp;&nbsp;I'd appreciate if you could share any insights/tips/tricks/resources. Thanks!

vastg · Answer

tejasruparel&nbsp;
&nbsp;
Refer to this posts on how to dynamically change the attribute. Its not exactly what you need but the idea is same.
&nbsp;
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
https://community.powerbi.com/t5/Desktop/Change-x-axis-categories-dynamically/m-p/280583
&nbsp;
If it helps, mark it as a solution
Kudos are nice too

v-yuta-msft · Answer

tejasruparel&nbsp;,
&nbsp;
I'm confused on your description, could you please clarify the meaning of "Query1, 2, 3" and "Col1~5"? And which columns are the three slicers based on?
&nbsp;
Regards,
Jimmy Tao

tejasruparel · Answer

Hey Jimmy,&nbsp;So query1, 2 and 3 refer to 3 different query tables.&nbsp;and Col1 - 5 refer to columns within these three tables.&nbsp;see attached picture.&nbsp;&nbsp;

v-yuta-msft · Answer

tejasruparel&nbsp;,
&nbsp;
So does X-axis and Y-axis take the columns from two tables? Could you share more details?
&nbsp;
Regards,
Jimmy Tao

tejasruparel · Answer

Hey Jimmy,Please see attached pbixMy original plan was to be able to:Select what Sections to compare (multi-select slicer for Section 1, Section 2 and Section 3)Select what metric (column) to plot on x-axis (single select slicer for thickness, mass, intrusion etc.)Select what metric (column) to plot on y-axis (single select slicer for thickness, mass, intrusion etc.)So, the goal was to plot, for example - mass vs intrusion for Section 1 and Section 2---After spending some time trying to figure out a good approach I ended up transforming my data as follows:Create a new source w/ all Sections combined and respective columns aligned, and Add a column to index each unique rowDuplicate this Table and unpivot all metric columns -&nbsp;Combined_unpivoted_XDuplicate this Table and unpivot all metric columns -&nbsp;Combined_unpivoted_YNow I'm able to dynamically choose what sections to compare (using multi-select slicer) and what Xvalue and Yvalue to plot (using the single select slicer), but when I plot Xvalue vs Yvalue the scatter chart says 'Can't determine relationship between fields'.&nbsp;I have tried defining relationships, but it still won't plot&nbsp;Xvalue vs Yvalue, and I'm not sure why!&nbsp;In the attached file - you'll see I'm able to pull all the necessary data - just not able to plot it!&nbsp;I'd appreciate if you could take a quick peek at it and let me know if I'm missing something.&nbsp;&nbsp;Thanks!!

Forum Discussion

Single scatter chart w/ dynamic XY axis

5 Replies

Related content

Scatter Chart

Dynamic scatter plot

Scatter chart.

Dynamic Filter

Time vs Time Scatter Chart