Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have sports data surrounding players and various metrics. I also have a table of games and the line-ups that were used. From this, I can calculate "Games Played" for any specific player, and slice that by date, league, etc. For example, if John Smith played 3 games in the British League and 4 games in the French League, the following results would be expected based on slicing by league:
British: 3 games
French: 4 games
Unselected/All: 7 games
I am having difficulty thinking of a way to slice the data by Games Played. I have tried creating an unrelated table and using that, however this unrelated table can only account for Games Played at the "All" level. If I want to slice by Games Played in the British League, it is not possible.
Is there any way to harness the selections of an In-Between Slicer for Games Played, that is dynamic and updates based on other filters on the page, such as League or Month? For example, expected results for the above example if I have filtered the entire page for British League would be:
Slicer showing 1 to 3 for Games Played. If there are players who have more than 3 games in the British League, it would update as such. However, even if this is not possible, I would like to be able to select 1-5 and have John Smith appear because he has 3 games, but if I select 4-8, he disappears because he has only 3 games (not 7, which is the total games in ALL leagues).
As a workaround, I have created separate pages for each League and used Calculated Columns of Games Played per League as my slicers.
Did you try using a What-If Parameter? Sounds like a case for that. If you're using a measure and not a column for your games played calculation, this should respect the filter context of league and player, etc.
Thanks for the suggestion. I created a What-If for 0-40 games, incremented by 1. I wrote a measure that states to return the KPI only if the [Game Count] > Slicer Selection of the What-If. This seems to produce expected results from a table, as players who have fewer than the selected number of games don't have any values populated in the column. However, the column total remains unchanged. I would expect the column total to reduce as the number of games goes up. It also doesn't function like a normal slicer, in a way that I'd want those players who have fewer than the selected number of games to simply disappear.
I created this after researching What-Ifs only briefly. If there is a better way to do it, I would be interested in learning. Additionally, it would be nice to harness the selected values of a slicer that is set to "Between" rather than a single selection.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!