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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
So I needed to make a report that is heavily sanitized. It's for construction of a mine shaft.
Attached shows you the hours booked for crews on the previous week.
See the matrix. But I only want to show details of set 117, 118 and 119. That's where I thought if I could use selectedvalue for those three sets to filter and populate the cards it might work. Is it possible to use selectedvalue multiple times on 1 page? Or is there a better way?
Solved! Go to Solution.
Hi, @kylee_anne
Based on the information you have provided, Here are my answers to your questions.
1. I reproduced the matrix based on the information you gave me.
2. You want to get just the three groups 117, 118, 119, I think you can use both slicer and filter a little better.
Create a slicer based on set, then just check 117, 118, 119.
You can also filter the Set in Filters.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @kylee_anne
Based on the information you have provided, Here are my answers to your questions.
1. I reproduced the matrix based on the information you gave me.
2. You want to get just the three groups 117, 118, 119, I think you can use both slicer and filter a little better.
Create a slicer based on set, then just check 117, 118, 119.
You can also filter the Set in Filters.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.