Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
@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
User | Count |
---|---|
117 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |