Forum Discussion
Power BI Slicer Sorting
Hi Anonymous
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
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!
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