If my card visual label is dependent on the item selected from the filter, How to label "All"?

[Anonymous]

Hi All,

There is one filter with Team names listed as dropdown list and I have a label(Regular Card visual) with team names in my 2nd page.

So When I am selecting any teams from the filter, which is placed in the first page and clicking the "GO" button, it goes to second page with sync slicer feature and show me the correct "Team name" in the 2nd page.
But when an user is not selecting any Teams from the dropdown in the first page, it should label that page as "ALL" in the 2nd page instead of taking the "First Team name" from the dropdown list.

I need "All" as a label in the card visual which is placed as a header of that 2nd page, when no teams is being selected in the first page.

Is it possible? 

Thanks in advance.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

 

 

Best regards,
Lionel Chen

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

[Anonymous]

Yes you answered my question :). Thank you so much.

[Anonymous]

@v-lionel-msft  Hi Lionel,

How are we passing the "team name" as parameter to the next page. I tried your code but evertime it is displaying "All" as the label. Any idea what am i missing?

Before I was using Sync slicer feature to pass team name to my 2nd page. But when I am using the way you used as "Page Navigation", it is not working .

Measure Team =

IF(

ISFILTERED(Teams[name]),

SELECTEDVALUE(Teams[name]),

"ALL"

)

[Anonymous]

Yes got it. Your Slicer was hidden there. Thanks.

[amitchandak]

@Anonymous , I doubt you can make slicer to select first value

[Anonymous]

@amitchandak I dont want to select First value in the card visual, but when you display a Text in a card visual, it by defaults takes the First  as checked in the field section of visualisation panel. my requirement is when no items is selected from the dropdown list, what should be labeled in the card visual in the same page or the other. I want "All" there as Label but not the First item from the list.