Data from multiple columns into X-axis on scatter diagram

[sw123]

Hi,

I would need to put in numeric data from multiple columns into the X-axis on a scatter diagram. Is this possible and how would I do this?

Thankful for help!

[Anonymous]

Hi @sw123 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@sw123 , you can put from one column, Do you want the dynamic axis

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

But as in this case, it is a measure on-axis, this should be working

measure slicer

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

How to use

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

[sw123]

I tried the measure slicer, but with the columns instead of measures, since I don´t want any sums in the scatter diagram, I want all the values. But I could not get the SWITCH-function to work. It doesn´t recognize the last column name and I can´t figure out why.

[Anonymous · Accepted solution]

Hi @sw123 

You may not be able to change the column by slicer. I think measure is a better way.

I build a measure in X axis and it works well.

Measure = SWITCH(
Slicer[Selected Measure],1,[Column1],2,[Column2]
)

Result:

If this reply still couldn't help you solve your problem, could you show me your data model and your calculated column to me?

You can provide me more details about you problem, just like provide me with your problem screenshot, the result you want.

Or you can share you pbix file with me by your Onedrive for business.

You can download the pbix file from this link: Data from multiple columns into X-axis on scatter diagram

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.