User designed hierarchies (Ex. User is able to drag and drop fields that will display in that order)

[Anonymous]

Is there a way for the user to create dynamic hierarchies within a report? I have a lot of fields and they don't necessarily have a defined hierarchy. Certain fields do not matter to specific users, so I wanted to give them the capability of creating their own hierarchy to filter the data. One example I envinsioned was a drag and drop where the user could change the hierarchy on the fly. Examples:

School

Teacher

Student

Teacher 

Student

School

Class 

Teacher

Student

[Hariharan_R · Accepted solution]

Hi,

Drag and drop the fields on the fly will be a easiest approach for users. Otherwise you also create a field parameters and can allow users to choose whatever fields that they want to add one by one on hierarchy.

Refer - https://www.sqlbi.com/articles/fields-parameters-in-power-bi/

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin