Lean how to use measures in slicers

[parry2k]

Ever found yourself wanting to use measures in slicers but hitting a roadblock? We've got your back! This latest video is all about disconnected tables and how they can solve this puzzle for you. This video will walk you through the exciting process of using measures in slicers, opening up a whole new dimension of data control.

What is a disconnected table: In Power BI disconnected tables play a crucial role in enhancing data modeling and analytical capabilities. These tables are used to create relationships between data, but unlike traditional relationships, they don't affect the filtering of other tables in the data model. This unique characteristic provides several valuable benefits: 👇

👉Solving Complex Business Problems
👉Custom Hierarchies
👉User-Driven What-If Analysis
👉Parameter Tables

In summary, disconnected tables in Power BI offer unparalleled flexibility and interactivity, allowing users to tackle complex business challenges, perform dynamic analyses, and customize data views without altering the core data relationships.

Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI and Fabric - youtube.com/@PowerBIHowTo

[Rufyda]

Hi @parry2k  
Thanks for sharing this, really helpful explanation.
Disconnected tables are a great approach for using measures with slicers, and you explained the concept very clearly. Appreciate you taking the time to put this together and share it with the community.

Regards,
Rufyda Rahma | MIE

[vaibhavmahajan]

Hi @parry2k ,

I hope you are doing well today 🙂❤️

Great explanation!
Disconnected tables are a powerful concept in Power BI, especially when you want measures to respond to slicer selections without impacting the core data model. They enable clean what-if scenarios, dynamic KPIs, custom sorting, and parameter-driven logic while keeping relationships intact and performance optimized.

This approach is a must-know for anyone working on advanced interactivity and complex business logic in Power BI. Thanks for sharing such a practical use case! 👍

If this answer helped, kindly give Kudos and mark it as the Accepted Solution

to help other members find it more quickly.

Best regards,

Vaibhav Mahajan

LinkedIn: https://www.linkedin.com/in/vaibhavnmahajan