Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.