Forum Discussion

krutcher's avatar
krutcher
Regular Visitor
4 years ago

Dynamically change titles by using a hierarchy level

Hi PowerBI Community,   I have 2 levels of the hierarchy in the in the TreeMap visual. 1st one is Origin and 2nd one is Channel. I have to create a dynamic title which will be displayed according ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Greg_Deckler, 
    I'm having this issue too even using ISINSCOPE for a line chart visual. 
    Here's the DAX Code I'm using:

     

    Historical view hierarchy - Dynamic Title :=
    VAR HierarchyLevelSelected =
    SWITCH(
        TRUE(),
        ISINSCOPE(Dim_CalendarDate[YearInt]),"Yearly View"
        ,ISINSCOPE(Dim_CalendarDate[CalendarQuarter]),"Quarterly View"
        ,ISINSCOPE(Dim_CalendarDate[CalendarMonth]),"Monthly View"
        ,ISINSCOPE(Dim_CalendarDate[CalendarWeek]),"Weekly View"
        ,ISINSCOPE(Dim_CalendarDate[CalendarDate]),"Daily View"
    )
    RETURN
    "Historical " & HierarchyLevelSelected

     


    This is returning the following value in the title:
     "Historical "

    Do you know another way to extract the hierarchy level from the X axis and use it on the Visual Title? 

    krutcher - did you find a workaround?

    Thanks for your help,
    Victor Andarcia