Scatter Chart Query

[alext89]

Hi There, 

I have loaded a CSV into Power BI desktop. Each of the KPI's are a different row in the CSV however that means all the values are in the same column, so when i go to plot a scatter chart i cant plot one of the KPI's against another. I thought there might be a way to have different filters for the x and y axis but i cant seem to find it. Anyone got any ideas? 

Cheers

[v-huizhn-msft]

Hi @alext89,

>> Each of the KPI's are a different row in the CSV however that means all the values are in the same column.

It's confusng, in your resource data table, there must have many different rows in one column, when you load it into Power BI desktop, there are still in one column. Why you said "all the values are in the same column", they should not in one column?

When you create a scatter chart, you can filter the value by "visual level filters" highlighted in red line.




Best Regards,
Aneglia

[alext89]

yes the CSV is set out like this:

Month	Metric	Value
Jan	Metric 1	3
Jan	Metric 2	4
Jan	Metric 3	2
Feb	Metric 1	5
Feb	Metric 2	2
Feb	Metric 3	4
Mar	Metric 1	1
Mar	Metric 2	4
Mar	Metric 3	2

I want to be able to plot for example metric 2 as the x axis and metric 1 as the y axis for each month. Does that make more sense?

[v-huizhn-msft]

Hi @alext89,

As I testet, it we are unable to get what you want. It makes no sense in PowerBI visual.

Thanks,
Angelia