sorted a data as filter uing a Query

[ali_a]

I have a column in oracle table has main branches and store in the same table and every each main branch has a unique number like 100, 200, 300. the main branch one has five stories start from 101 to 106. how can I show the five main branches in the filter without a small branch? when I click on the main branch will show the small branch.

[v-frfei-msft · Accepted solution]

Hi @ali_a ,

To use grouping and binning in Power BI Desktop should help you. One sample for your reference as below: