cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

## To make one slicer selection as fixed and remaining as dynamic

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??

2 ACCEPTED SOLUTIONS
Resolver II

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.

Resolver II

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.

5 REPLIES 5
Resolver II

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.

Helper IV

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

Resolver II

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.

Helper IV

@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)?

Resolver II

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.

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors