Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MoeData
Advocate II
Advocate II

Multiple Filtered Series in a single scatter plot

I want to compare two series of data on a single scatter plot. 

I have tables that are filled with data about employees. I have attached a PBIX file.
I would like make a dashboard where I have multiple groups of slicers and each group of slicers contains some filters.  Then I would like to show different series of data, that are filtered based on each group of slicers, in a single scatter plot.

As shown in the sample file, under the “Slicer Group 1”, there are a bunch of filters. Next to the “Slicer Group 1” there should be a checkbox where I can activate/deactivate the whole group of slicers (or any other arrangement that gives the ability to turn the results from the whole group filters visible/invisible). Then I would like to see the results in the scatter plot.

 

For comparison, there is also a  “Slicer Group 2” with the same bunch of filters (they should be modified independent from filters in “Slicer Group 1” of course). I then like to see this series of data on the same scatter plot so I can compare the results I get  from “Slicer Group 1” to the ones I get from “Slicer Group 2”.

What is a smart way to do this? A BPIX file is much appreciated.  

Link to the PBIX file:
https://tinyurl.com/2p9b2stv
dashboard.png

2 REPLIES 2
MoeData
Advocate II
Advocate II

@amitchandak No, they don't create measures.

amitchandak
Super User
Super User

@MoeData , I am assuming these two filters will generate measures. First of all you need independent tables for those additional slicer.

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

 

Once you got two measures, you need to create a calculation group and use than in legend. You already should have details and two axis

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.