How to make slicer selection fixed?

[Likhitha]

Hello All,

   I created a funnel chart to compare sales of my selected country w.r.to other countries,the country which i selected will be taken as 100% and will be compared with rest of the countries...but I want one selection as fixed,how to do that?? In the below picture i want canada country as fixed and i dont want to make any other selection.

[Anonymous]

@Likhitha - You could use a page-level or report-level filter, instead of a slicer visual. With filters, you can optionally lock and optionally hide the selection.

Hope this helps,

Nathan

[Likhitha]

@Anonymous  ...thank you for responding...

https://community.powerbi.com/t5/Desktop/How-to-make-selected-country-as-reference-country-for/m-p/661873#M317995

This is the original post ...from that i want make my requirement.

---

@Anonymous wrote:

@Likhitha - You could use a page-level or report-level filter, instead of a slicer visual. With filters, you can optionally lock and optionally hide the selection.

Hope this helps,

Nathan

---

[Anonymous · Accepted solution]

@Likhitha  - If you always want Canada, you don't actually need a slicer at all - you can hard code that in your sorting measure: 

Measure = IF(SELECTEDVALUE('Table'[Country]) = "Canada",1)

Cheers,

Nathan

[Likhitha]

thank you  @Anonymous  🙂 ,It's Working