Power BI table , when filter values desapear

[Bruce101995]

Hello, 

Hope you all doing well.

I have a table where I have the Structural costs and the Budget. 
I n the table some lines have no value ,so in the filter section I put "greater then " 0, but when I do that the budget values disapear. Can you help ? Please

This is the table:

When I put the filter:

Thank you!

[burakkaragoz · Accepted solution]

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:

1. 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,
    ...
)

1. Sort your slicer field by this 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.

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

[v-aatheeque]

Hi @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!