Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |