Forum Discussion

laura8685646's avatar
laura8685646
New Member
5 years ago
Solved

Multilevel Slicer

Hi there,   I am looking to use a multi level slicer for a project forecasting report. I want the report to be able to filter both by year (top hierarchy) and by spend type (project milestones). Th...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi laura8685646 

    In addition to Fowmy‘s reply, you may need to use split function after you unpivot the columns.

    Due to I don't know your data model, I build a sample table.

    Unpivot all columns and then split Attribute column by space.

    Finally, you can build a hierachy slicer by Attribute 1 column and Attribute 2 column.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

laura8685646 

 

You can use the Slicer Visual in Power BI Desktop to achieve it. You can include your fields in the fields selection and it will form a hierarchy, further, Show ALL option can be turned on as well.

 

Please check the example below

 

 

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

  • laura8685646's avatar
    laura8685646
    New Member
    5 years ago

    Hi Fowmy, 

    I think if the data had been set up differently, this would be an appropriate answer.
    The challenge I am finding is the values are set up for Y/N, where the fields which I am more needing are the column headers. There must be a work around rather than reconfiguring a full data set and its sources. So the question is can you still do this hierarachical slicer if the fields are column headers rather than values?

    Thanks,

    Laura