To make one slicer selection as fixed and remaining as dynamic

[Likhitha]

Hello all,

    Is it possible to make one slicer selection fixed at first position and other slicer selections are dynamic in power bi??

 In the above picture,I want to make USA as my fixed selection for all years and USA bar should be in first position, Is it possible??

[JoyCornerstone · Accepted solution]

 Add a column to the table with the countries called Sort Order that has unique values. USA would be 1.  Then select the Country Name column and in your toolbar select "Sort By Column"  and the "Sort Order" or Index or whatever you named it.

[ntaylo06 · Accepted solution]

If I am understanding correctly you want the US to always be shown first in bar clusters and then all other countries listed after in no particular order. To do this follow these steps:

1. Duplicate your data source (or start a fresh one from the same data source)

2. Remove all columns except for [Country] and name the table something like 'Legend Sort'

3. Create a new calculated column in 'Legend Sort' that uses this logic: 

Sort Order = IF([Country] = "USA", 1, 2)

4. Create a relationship between 'Legend Sort' and your data 

5. Select the [Country] field in your clustered bar visual and then sort it by column like JoyCornerstone said (above). You should then be able to sort by [Sort Order] and USA will be displayed first.

 Here is a link to a useful blog post. Let me know if this makes sense.

[Likhitha]

@ntaylo06 , @JoyCornerstone  Its Working ...Thank You 🙂

[JoyCornerstone · Accepted solution]

 Add a column to the table with the countries called Sort Order that has unique values. USA would be 1.  Then select the Country Name column and in your toolbar select "Sort By Column"  and the "Sort Order" or Index or whatever you named it.

[Likhitha]

@JoyCornerstone  i'm having different years data with same countries in one table,so how to give  sort order number for same countries (mean the same number for same countries r else different number)?

[JoyCornerstone]

That's a problem. In order for it to work, you'll have to add a Country Table with a sort order and link that to the country you have in the table you are looking at here.