Forum Discussion
Create hierarchy for filter from the same table
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: ...
Anonymous,
Import Hierarchyslicer custom visual to Power BI Desktop, then create HierarchySlicer.
Regards,
Lydia
Yes!
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.