Forum Discussion
Column based filtering in scatter plot
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 ?
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
2 Replies
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
Dear amitchandak
I would like to have a Power BI certified visual. Can you please help me out with this?
