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.