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 #powerbi, 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.
Enjoy and share, and leave your valuable and constructive feedback.
Link to learn the use case of Generate DAX functions: youtu.be/FR65SdqoHbs
Link to download the pbix file: tinyurl.com/38267pxe
Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI - youtube.com/@PowerBIHowTo
🌏: perytus.com/
✍: perytus.com/blog/
📞: perytus.com/contact/
0:00 - Introduction
0:46 - Problem Statement
3:30 - Challenge and the reason for this video
5:36 - Let's work on the solution
11:05 - Disconnected table to rescue
12:29 - We need a measure
16:55 - Stitch it all together
17:29 - Wrap up and what's next?
#powerbi #businessintelligence #bi #perytus #decipheryourdata #powerbipro #powerbideveloper #dax #fieldparameters #calculationgroups #learnpowerbi #howtopowerbi #powerbitraining #powerbiforbeginners #dataanalysis #microsoftpowerbi #microsoftpowerbidataanalysis #visualinteraction #visualizaton #disconnectedtables #datamodeling #slicer #slicers #powerbislicers
- Mastering Disconnected Tables - Use measures in slicers in Power BI | PeryTUS - Power BI How To ( Download)
- Mastering Disconnected Tables -Solve Complex Problems in Power BI | PeryTUS - Power BI How To ( Download)
- THREE WAYS to use DISCONNECTED TABLES in Power BI // Beginners Guide to Power BI in 2023 ( Download)
- How to override slicer selection to return all records | PeryTUS - Power BI How To ( Download)
- DAX Magic - Disconnected Slicers in Power BI. Example for changing the currency ( Download)
- Power BI Fetch Results from disconnected table(No Joins Used)| Treatas Function| disconnected tables ( Download)
- Conditional Formatting using Power BI Disconnected Slicers ( Download)
- Greg Deckler with the ULTIMATE guide to using DISCONNECTED TABLES in POWER BI. ( Download)
- Unleash the Magic of NATURALINNERJOIN DAX function in Power BI! ( Download)
- Custom Tooltip in Power BI and Running Total Challenge - Use of Sync Slicer and TREATAS DAX function ( Download)
- Learn TOP 3 use cases of new FIELD parameter feature introduced in May 2022 Power BI Update ( Download)
- How to use Calculated Measure as a Slicer with Bonus PL -300 Question ( Download)
- How to use a measure as Slicer ( Download)
- Abstract Thesis 71: PowerBI How to filter slicer of disconnected table Dimension to filter Dimension ( Download)
- Unlocking Time Intelligence in Power BI: Simplifying DAX Measures with Pattern Table | PeryTUS ( Download)
