Dynamic title with date hierarchy

[Anonymous]

Hi,

I want the title of a bar chart to show "Yearly sales" when I am at the yearly level, "Quarterly sales" when I am at the quarter level and so on. 
I have tried this:

Average mm/hr title =

    SWITCH (

        TRUE (),

        ISFILTERED('Date'[Year]),

            "Yearly sales",

        ISFILTERED('Date'[Quarter number]),

            "Quarterly sales",

        ISFILTERED('Date'[Month No]),

            "Monthly sales",

        BLANK ()

    )

[ribisht17]

Hi @Anonymous 

Please find a few examples here

1. https://community.powerbi.com/t5/Desktop/Create-a-Dynamic-Title-Using-a-Hierarchy/m-p/1602435

2. https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-Title/m-p/3107324

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Kishore_KVN]

I think you can achieve this using 'SELECTEDVALUE' DAX instead of 'ISFILTERED'. Have you tried this?