Solved: sorted a data as filter uing a Query

ali_a · ‎10-06-2019

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 · ‎10-06-2019

Hi @ali_a ,

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎10-06-2019

Hi @ali_a ,

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.