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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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