Forum Discussion
Power BI table , when filter values desapear
Hi Bruce101995 ,
At the moment, Power BI’s Button Slicer Grid doesn’t support changing 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 gives you more control over the order:
- Create a custom sort column in your data model that reflects the order you want the buttons to appear in (top to bottom, then left to right).
SortOrder = SWITCH( [YourField], "Option A", 1, "Option B", 2, "Option C", 3, ... )Sort your slicer field by this SortOrder column.
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.
Hopefully Microsoft adds a native toggle for this in the future, but for now this method works well.
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
Super UserHi Bruce101995 ,
At the moment, Power BI’s Button Slicer Grid doesn’t support changing 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 gives you more control over the order:
- Create a custom sort column in your data model that reflects the order you want the buttons to appear in (top to bottom, then left to right).
SortOrder =
SWITCH(
[YourField],
"Option A", 1,
"Option B", 2,
"Option C", 3,
...
)Sort your slicer field by this SortOrder column.
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.
Hopefully Microsoft adds a native toggle for this in the future, but for now this method works well.
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
Community SupportHi Bruce101995
Just checking in burakkaragoz has shared a response to your query on when filter values desapear.
If the solution was helpful, please consider marking it as Accepted Answer — doing so helps others in the community who may face similar challenges.
If you need further clarification or are still experiencing issues, feel free to provide more details — we’re happy to assist further.
Thank you for being part of the Microsoft Fabric Community!
- v-aatheeque
Hey Bruce101995 ,
Regarding your issue where applying a filter like > 0 causes the Budget values to disappear.
If the burakkaragoz shared workaround helped resolve your issue, we’d appreciate it if you could mark it as the Accepted Answer, this helps recognize contributions and benefits others in the community as well.Let us know if you need more help or adjustments we’re here for you!
Thanks again for being part of the Microsoft Fabric Community!- v-aatheeque
Hi Bruce101995
Following up on the issue you mentioned about Budget values disappearing when applying a filter such as
> 0.If the workaround suggested by burakkaragoz helped resolve it, kindly consider marking the response as the Accepted Answer — it acknowledges their input and can be useful for others facing similar challenges.
If you still need further assistance or refinements, feel free to share more details — we're here to help!
Thanks again for being part of the Microsoft Fabric Community!