01-13-2017 01:28 PM - edited 01-13-2017 01:39 PM
I have the following data:
- LATAM (h1)
- ASIA (h1)
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!
01-13-2017 07:45 PM
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
01-16-2017 05:53 AM - edited 01-16-2017 07:31 AM
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:
- Measure = IF(ISFILTERED(DisconnectedDestination[H1]),1,0)
This calculated column is on the original destination table:
- Column = IF([Measure]=0 , Destination[H1], Destination[H2])
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?
01-17-2017 09:49 PM
I noticed you mentioned two tables DisconnectedDestination and Destination. Would you please share some sample data and desired results for our analysis?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.