cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Likhitha Regular Visitor
Regular Visitor

How to make slicer selection fixed?

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.

CaptureFixed.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
natelpeterson New Contributor
New Contributor

Re: How to make slicer selection fixed?

@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

4 REPLIES 4
natelpeterson New Contributor
New Contributor

Re: How to make slicer selection fixed?

@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 Regular Visitor
Regular Visitor

Re: How to make slicer selection fixed?

@natelpeterson  ...thank you for responding...

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

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


@natelpeterson 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


 

natelpeterson New Contributor
New Contributor

Re: How to make slicer selection fixed?

@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 Regular Visitor
Regular Visitor

Re: How to make slicer selection fixed?

thank you  @natelpeterson  Smiley Happy ,It's Working