Create hierarchy for filter from the same table

[Anonymous]

Hi all, I was trying to group the data from a table column (brand) into A, B, C....Z so that I can use them as the filter. Example as shown below:

TableName:

Data in column 'brand' showing in filter now:

What I want to achieve:

Hopefully someone can guide me through this, thank you!

[v-yuezhe-msft]

@Anonymous,

You can use Grouping feature in Power BI Desktop to group the data into A,B,C….Z, then you are able to filter data using the group column.



Regards,
Lydia

[Anonymous]

Hi @v-yuezhe-msft and @AGo,

Thanks for the reply!

Just wondering if I can achieve something similar to the example below instead of grouping them as I want to show it in a dropdown list: 

Cheers!

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Import Hierarchyslicer custom visual to Power BI Desktop, then create HierarchySlicer.




Regards,
Lydia

[AGo]

Are you meaning you want to filter brands by the first letter?

[Anonymous]

Yes!

[AGo]

You have to create a new column in the table brands with the LEFT function: LEFT(brand;1) .

And use that column in your filter.