Want to create a dynamic title for two filters

[MKumar_17]

Hi All,

I have two filters managers and Employees. I want to create a dynamic title based on selection of filters

Eg. If I select a manager and also select a employee then dynamic title is working fine. As shown below.

But as I select only from employee filter then manager name is also coming in dynamic title which I don't require. As shown below. 

I want to see title with only which filter value is selected 

Thanks!

[Anonymous · Accepted solution]

Hi, @MKumar_17 

You can try using the following measure to solve your need.

dynamic_header = 
VAR _manager =
    IF ( ISFILTERED ( Sheet1[Managers] ), MAX ( Sheet1[Managers] ) )
VAR _emp =
    IF ( ISFILTERED ( Sheet1[Employees] ), MAX ( Sheet1[Employees] ) )
RETURN
    IF (
        ISFILTERED ( Sheet1[Employees] ) && ISFILTERED ( Sheet1[Managers] ),
        "Detailed Report" & " of managers " & _manager & " for employee " & _emp,
        IF (
            ISFILTERED ( Sheet1[Employees] ) && ( NOT ISFILTERED ( Sheet1[Managers] ) ),
            "Detailed Report" & " for employee " & _emp,
            IF (
                ISFILTERED ( Sheet1[Managers] ) && ( NOT ISFILTERED ( Sheet1[Employees] ) ),
                "Detailed Report" & " for manager " & _manager,
                "Detailed Report" & " of managers " & " for employee "
            )
        )
    )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous · Accepted solution]

Hi, @MKumar_17 

You can try using the following measure to solve your need.

dynamic_header = 
VAR _manager =
    IF ( ISFILTERED ( Sheet1[Managers] ), MAX ( Sheet1[Managers] ) )
VAR _emp =
    IF ( ISFILTERED ( Sheet1[Employees] ), MAX ( Sheet1[Employees] ) )
RETURN
    IF (
        ISFILTERED ( Sheet1[Employees] ) && ISFILTERED ( Sheet1[Managers] ),
        "Detailed Report" & " of managers " & _manager & " for employee " & _emp,
        IF (
            ISFILTERED ( Sheet1[Employees] ) && ( NOT ISFILTERED ( Sheet1[Managers] ) ),
            "Detailed Report" & " for employee " & _emp,
            IF (
                ISFILTERED ( Sheet1[Managers] ) && ( NOT ISFILTERED ( Sheet1[Employees] ) ),
                "Detailed Report" & " for manager " & _manager,
                "Detailed Report" & " of managers " & " for employee "
            )
        )
    )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[MKumar_17 · Accepted solution]

Thank you so much @Anonymous 

[MKumar_17]

Adding .pbix file link:

https://github.com/mohitkumar-Tyagi/power-Bi-/blob/main/dynamic_title.pbix