Dynamic Title When Drilling Down

[djoellet]

Hello,

I am a new PBI user and I am having the hardest time creating a dynamic title for my chart when drilling down.  I have been successful before when there is only one level two drill down but I am getting stuck with drilling down twice.  Below is an example of my levels.  Any assistance would be appreciated.  Thank you!

Category

Subcategory

Product 

[amitchandak]

@djoellet , Check for isfiltered or hasonevalue

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[djoellet]

Thank you for your response!  I wanted to provide additional details, below is the formula I am using:

Title Label =

var Category = SELECTEDVALUE('May 2022'[Category])

var Subcategory = SELECTEDVALUE('May 2022'[Subcategory])

var Product = SELECTEDVALUE('May 2022'[Product])

Return

IF (ISFILTERED('May 2022'[Category]),

     Category & " Detail",

        IF(ISFILTERED('May 2022'[Professional Subcategory]),

             Subcategory & " Detail"),

                IF(ISFILTERED('May 2022'[Product]),

                    Product & " Detail")

[SpartaBI · Accepted solution]

@djoellet 
Try this:

Title Label =

Label =
VAR Category =
    SELECTEDVALUE ( 'May 2022'[Category] )
VAR Subcategory =
    SELECTEDVALUE ( 'May 2022'[Subcategory] )
VAR Product =
    SELECTEDVALUE ( 'May 2022'[Product] )
RETURN
    IF (
        ISINSCOPE ( 'May 2022'[Product] ),
        Product & " Detail",
        IF (
            ISINSCOPE ( 'May 2022'[Professional Subcategory] ),
            Subcategory & " Detail",
            IF (
                ISINSCOPE ( 'May 2022'[Category] ),
                Category & " Detail"
            )
        )
    )

Showcase Report – Contoso By SpartaBI