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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Nick_R
Frequent Visitor

Is there a way to get a Button Slicer Grid to populate down then across?

I'm using a button slicer in a grid of 2 columns and five rows.

 

The slicer values are displaying in the correct order, but are popluated across, then down, whereas I would like them to populate down then across.

 

Is there are setting that allows me to do this?

1 ACCEPTED SOLUTION
burakkaragoz
Community Champion
Community Champion

Hi @Nick_R ,

 

Yeah, currently the Button Slicer Grid in Power BI doesn’t support a native setting to change the fill direction from “across then down” to “down then across.” It always fills row-wise by default.

That said, here’s a workaround that might help:

  1. Reorder your data: Create a calculated column that assigns a custom sort order based on how you want the buttons to appear (top to bottom, then left to right). For example:
SortOrder = 
SWITCH(
    [YourField],
    "Option1", 1,
    "Option2", 2,
    "Option3", 3,
    ...
)
  1. Sort your slicer field by this new SortOrder column.

  2. Then adjust the grid layout (e.g. 2 columns, 5 rows) to match the visual structure you want. It won’t change the fill direction, but it will control the order in which items appear.

Unfortunately, there’s no toggle to change the fill direction itself — but this trick helps you control the visual flow.

Hope that helps.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

View solution in original post

4 REPLIES 4
Nick_R
Frequent Visitor

Hello @burakkaragoz , thank you very much for confirming that this is not currently possible, and for the workaround suggestion.

 

Hopefully this will be added in future releases.

Nick_R
Frequent Visitor

I've submitted an idea for this option to be added, in case anybody wants to vote for the feature:

 

Enhance button slicer to allow grid to be populated down then across 

BhavinVyas3003
Super User
Super User

No, Power BI does not have a built-in setting to make a button slicer grid populate down then across. It only supports across then down.

Manually reorder your data or create a calculated column to control the display order and simulate the "down then across" effect.


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!
burakkaragoz
Community Champion
Community Champion

Hi @Nick_R ,

 

Yeah, currently the Button Slicer Grid in Power BI doesn’t support a native setting to change the fill direction from “across then down” to “down then across.” It always fills row-wise by default.

That said, here’s a workaround that might help:

  1. Reorder your data: Create a calculated column that assigns a custom sort order based on how you want the buttons to appear (top to bottom, then left to right). For example:
SortOrder = 
SWITCH(
    [YourField],
    "Option1", 1,
    "Option2", 2,
    "Option3", 3,
    ...
)
  1. Sort your slicer field by this new SortOrder column.

  2. Then adjust the grid layout (e.g. 2 columns, 5 rows) to match the visual structure you want. It won’t change the fill direction, but it will control the order in which items appear.

Unfortunately, there’s no toggle to change the fill direction itself — but this trick helps you control the visual flow.

Hope that helps.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors