dynamic titles with conditions

[Anonymous]

Hi every one,
I'm new on power bi and I'm trying to figure out how I can make dynamic titles with these conditions:

" Dashboard for" &
- IF no departemnt  is seleted (just the selected value of the colomn departments), I want to see "All departemnts"
- IF 1 department is selected then I want the departement name
- IF more than 2 departemnts are selected then it must show " Many departemnts"

Thanks in advance.

[Anonymous]

@selimovd No, I dont use hierarchy in any slicer. Actually I'm not working with slicers but filters. This is how it comes when I choose more than one departmnts.

[selimovd]

Hey @Anonymous ,

that should still work.

Can you show me the measure you used? Maybe I can see a reason there.

Best regards

Dens

[Anonymous]

Sure. Here is the measure I used:

= "Dashboard for - " &

SWITCH( TRUE(),

NOT( HASONEVALUE( DimDep[Departmnts]) ), " All departmnts",

COUNTROWS(VALUES(DimDep[Departmnts])) > 1, " Many departmnts",

SELECTEDVALUE(DimDep[Departmnts]

)

Thanks,

[selimovd]

Hey @Anonymous ,

you didn't use the measure I proposed. That's the reason the result is different 😉

Try to use the one I proposed:

myDepartmentName =
"Dashboard for - "
    & SWITCH( TRUE(),
        NOT ( ISCROSSFILTERED( DimDep[Departmnts] ) ), "All departemnts",
        COUNTROWS( ALLSELECTED( DimDep[Departmnts] ) ) > 1, "Many departemnts",
        SELECTEDVALUE( DimDep[Departmnts]Hey )
    )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[ERD]

Hello @Anonymous ,

You can try this measure:

dyn_title = 
IF(NOT(ISCROSSFILTERED(T[Department])), 
"All departments",
SELECTEDVALUE(T[Department], "Many departments"))

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[selimovd · Accepted solution]

Hey @Anonymous ,

I would do it like that:

myDepartmentName =
"Dashboard for"
    & SWITCH( TRUE(),
        NOT ( ISCROSSFILTERED( MyTable[departments] ) ), " All departemnts",
        COUNTROWS( ALLSELECTED( MyTable[departments] ) ) > 1, " Many departemnts",
        SELECTEDVALUE( MyTable[departments] )
    )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thanks for your assistance @selimovd. I try your example,  but when I select more than 1 value, it's showing me "All departmnts" instead of "Many departmnts". How can I fix that please? 

[selimovd]

Hey @Anonymous ,

do you use a hierarchy in your slicer? Can you send me a screenshot of your solution?

For me it works, like this you wanted it, right:

Best regards

Denis