Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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:                     ...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

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




    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Anonymous,

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




      Regards,
      Lydia