Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Hierarchy Slicer not working correctly with disconnected tables

Hey everyone!
It is my first time here and I hope that someone is able to help with my issue. 
I am using Hierarchy Slicer custom visual (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=DetailsAndSupport) for one of my projects and it is not behaving as excpected. 
I have added school ownerships and schools into the slicer fields. Everything works fine as long as there is more than one or two schools (leafs) under the ownership (picture below). "munitsipaal" is the ownership and "Emmaste Põhikool" is a school. 

Ingverk_1-1671798429196.png

 

Problem starts when there is only 1 or 2 schools as a choice as it is with "Hiiumaa Vabakool" under "eraomand". It just won´t show up in the visual alone! But if I were to choose one from below (from another ownership where there are many) then they both show up in the visual. 
I have tried to check my measures and I do not believe it has anything to do with the measures, because exactly the same school shows up in the visual from a normal PowerBI visual while the measure inside the visual is exactly the same. 
NB! I ma using disconnected tables to add different schools to the visual. I will add example of the measure below: 

Valitud võrldusalused (KOV joonis):=

VAR NoLimit =
    CALCULATE (
        COUNT ( 'TNA_FactTulemusnaitaja'[value] ), TNA_FactTulemusnaitaja[Limit] = 0)


VAR Result = CALCULATE (
    AVERAGE ( 'TNA_FactTulemusnaitaja'[value] ),
    FILTER (
        'TNA_FactTulemusnaitaja',
        (
            'TNA_FactTulemusnaitaja'[AsutusID]
                IN VALUES ( DimKool_Filter1[AsutusID] ) && ISFILTERED ( DimKool_Filter1[NameClean])
        )
            || (
                'TNA_FactTulemusnaitaja'[AsutusID]
                    IN VALUES ( DimKool_Filter2[AsutusID] ) && ISFILTERED ( DimKool_Filter2[Name])                  
            )
            || (
                'TNA_FactTulemusnaitaja'[AsutusID]
                    IN VALUES ( DimKool_Filter3[AsutusID] ) && ISFILTERED ( DimKool_Filter3[Name] ) && 
 NoLimit
            )
            || (
                TNA_FactTulemusnaitaja[AsutusID]
                    IN VALUES ( DimKool_Filter4[AsutusID] ) && ISFILTERED ( DimKool_Filter4[
NameClean])
                    )
            || (
                TNA_FactTulemusnaitaja[AsutusID]
                    IN VALUES ( DimKool_Filter5[AsutusID] ) && ISFILTERED ( DimKool_Filter5[Name]) && 
 NoLimit

                   
                   
                           
            )
    )
)

RETURN Result

Has anybody an idea why is it doing so? 🙂 

Best wishes,

Kairi

Status: Investigating
Comments
Anonymous
Not applicable

Hi @Ingverk 

I tested as you said, but in my case everything is normal. What version did you use to test, Desktop has been updated to December, you can update Desktop to the latest version and test again.

Ailsamsft_0-1672023574676.png

Best Regards,
Community Support Team _ Ailsa Tao