Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have the following data:
Destination:
With the destination hierarchy presented above (which only Highest level of the hierarchy is in a slicer -h1-), I have a Matrix with destination on columns.
Basically, I need that when nothing is selected on the slicer, only h1 level is presented. But when any item on that slicer is selected, only h2 level is presented on the columns on that same matrix.
I think this is done using a calculated column but I'm not quite sure, I'm a PowerBi amateur!
In advance, thanks for any help!
David
Here are the component pieces that you need to understand:
1. Definitely this - ISFILTERED() - https://www.powerpivotpro.com/2013/03/isfiltered-a-better-way-to-detect-totals/
2. Maybe this - disconnected slicers - i can't find anything great on this ... looking
Hey @austinsense!
I already tried using the ISFILTERED(), but it is not working properly. I have a new column depending on the value of that filtered, something like this:
This measure is on the original destination table but refering to the disconnected table:
This calculated column is on the original destination table:
Despite that measure works perfectly when using the disconnected destination on a slicer (changes between 1 and 0 depending on filtering), the calculated column do not.
Any tip here?
Thanks,
David
Hi @ortizd,
I noticed you mentioned two tables DisconnectedDestination and Destination. Would you please share some sample data and desired results for our analysis?
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |