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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hi folks,
is it possible in PowerBI to have a dimension slicer records that *ONLY* contains the available related fact table records?
Akin to an Excel cube based slicer that ONLY highlights the slicer attributes that the related fact table contains!
for example, I have a dimension of 100 records but the related fact table only has 5 of these related keys. How can I make the slicer just display those records and not the entire dimension? --would that be feasible only if creating a M2M relationship?
thank you kindly,
Cos
Solved! Go to Solution.
@cosminioan , Take a measure from fact( Measure not column) and check that is not blank in slicer's visual level filter
This discussed here for two slicers, but work for 1 too
https://www.youtube.com/watch?v=cyOquvfhzNM
@cosminioan , Take a measure from fact( Measure not column) and check that is not blank in slicer's visual level filter
This discussed here for two slicers, but work for 1 too
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!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 40 | |
| 21 | |
| 18 |