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

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

Anonymous — Tue, 14 Jun 2022 12:59:13 GMT

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

Re: User designed hierarchies (Ex. User is able to drag and drop fields that will display in that or

Hariharan_R — Wed, 15 Jun 2022 05:02:29 GMT

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