Showing only one part of a sllicer

[maziiw]

I have a slicer which has two levels: REgion and Country. 

Example: Region = Americas, Country = USA,looks like below: 

I want to change the way the slicer displays - currently when I select the Country it shows the whole thing, so Region name(REgion) and Country Name (Country). Like below:

What can I do to change the display just to show the Country Name? So the below would only show United States without REgion part?

[MasonMA]

@maziiw 

Agree that using only 'country' in your slicer would be an option, but not sure if you can simply remove only the region from slicer, but i would create one new Calcualted column for 'Country', like 

CountryFilter = 'Table'[Country]

and use this field to replace the values in your slicer since the 'country' seems to be part of the hiearchy. 

[danextian · Accepted solution]

You mean to show jus the in my example the selected city and not Australia? That currently isn't supported. Only the header accepts a conditional text string.

[maziiw]

Hi @danextian  yes, I am wonderingif there is a way just to show that instead of the whole selection, when two levels of slicers are present

[SamsonTruong]

Hi @maziiw ,

To showcase just the country, I would recommend removing the region from the slicer visual. If there is a need to maintain the region information, another aproach would be to create 2 separate slicers, one for region, and one for country. This will allow you to slice on both fields, while displaying each field value in its own slicer.

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session