Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to build a matrix in which the user can arrange the dimensions in the line area as he likes. And that directly in the report. Currently, I have the option of using bookmarks to put a respective dimension to the head, ie on the first level of the hierarchy, but not to arrange the other underlying dimensions. The bookmark has a fixed table.
I have 7 dimensions in the line area, so I can not create a button for each constellation in the report. That would be too many.
In the example below, you can see how to solve this example in Qlik. You have the dimension names as buttons and you can drag and drop them as you want.
Anyone having an idea how to do that in Power BI?
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |