Column based filtering in scatter plot

[Jo5hua22]

Hi users

Can you please suggest some Microsoft certified Power BI scatter plot visuals or DAX commands to filter based on column names

Example:

Index created based on date.

Date	A1	A2	A3	Index
1/10/2021	10	5	8	1
2/10/2021	44	8	2	2
3/10/2021	8	54	56	3
4/10/2021	9	4	74	4
5/10/2021	98	86	63	5
6/10/2021	56	56	21	6
7/10/2021	23	58	23	7
8/10/2021	12	521	1	8

I want to create a scatter chart where the X axis is Index, Legend is Year, Y axis has A1, A2, A3

There should be a separate filter having the column names as A1, A2,A3. When the user clicks on A1, then only A1 data should be seen in the visual. Can you please help me out ?

[amitchandak · Accepted solution]

@Jo5hua22 , You should be able to do something like that in Charticulator

refer if this can help

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

[Jo5hua22]

Dear @amitchandak 

I would like to have a Power BI certified visual. Can you please help me out with this?