- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Power BI Slicer Sorting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @TANA
Unfortunately, with the old slicer visual, there's no option to change the layout once you've chosen the "Buttons" display mode.
You could add a sorting column in your data table to control the arrangement, but this isn't recommended as it doesn't represent proper sorting and may disrupt sorting in other visuals.
Therefore, the simpler and recommended solution is to use a different slicer:
1. The Chiclet Slicer from the marketplace.
Or the new slicer visual.
The pbix with the examples is attached.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
As per our understanding you want to change the setting of the slicer to display the years in a grid format
- Select the Slicer: Click on the slicer visual in your Power BI report.
- Change the Orientation:
- In the Visualizations pane, go to the Format tab (paint roller icon).
- Look for the Orientation setting under the General section.
- Change the orientation from Vertical to Horizontal.
- Adjust the Number of Columns:
- In the same Format tab, look for the Items section.
- Find the Number of columns setting and adjust it to match the number of columns you want (e.g., 5 columns for the years 2020 to 2024).
- Resize the Slicer:
- You may need to resize the slicer to fit the new layout. Drag the corners of the slicer to adjust its size.
- Sort the Years:
- Ensure that the years are sorted correctly. You can sort them in ascending or descending order by clicking on the More options (three dots) in the slicer and selecting Sort ascending or Sort descending.
Thanks!
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am new to power bi. can you please provide some further help to show where to find
I saw this when I select the slicer
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @TANA
If i understood you correctly and you are using new cards slicer you need to modify the overflow direction to vertical to have a wanted order :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am using the old slicer. And I would like to align the same format as other slicers on the same page. So would you mind giving me help based on old slicer. Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @TANA
Unfortunately, with the old slicer visual, there's no option to change the layout once you've chosen the "Buttons" display mode.
You could add a sorting column in your data table to control the arrangement, but this isn't recommended as it doesn't represent proper sorting and may disrupt sorting in other visuals.
Therefore, the simpler and recommended solution is to use a different slicer:
1. The Chiclet Slicer from the marketplace.
Or the new slicer visual.
The pbix with the examples is attached.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks, Rita. Appreciated!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
03-01-2024 06:03 AM | |||
12-19-2023 06:10 PM | |||
04-03-2024 02:06 AM | |||
02-12-2023 07:40 PM | |||
05-16-2024 07:25 AM |
User | Count |
---|---|
100 | |
80 | |
65 | |
42 | |
41 |
User | Count |
---|---|
96 | |
60 | |
55 | |
54 | |
50 |