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
Super 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