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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.