Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Likhitha
Helper IV
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??
SE.PNG

 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
JoyCornerstone
Resolver II
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.

Sort.PNG

View solution in original post

ntaylo06
Resolver II
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.

 

View solution in original post

5 REPLIES 5
ntaylo06
Resolver II
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.

 

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

JoyCornerstone
Resolver II
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.

Sort.PNG

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

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.  

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.