Forum Discussion
Dynamic rows, columns and values in matrix
I hope you get an answer, i have the same problem...
Anonymousno solution yet. I've left the report page as I described in my post above, with the row attribute determined dynamically with a slicer but the column attribute and displayed value fixed. It's not what I originally wanted to achieve but I think it's still useful.
Hi I have something similar that i need to create but probably a step further. I pull the data from a view which has consolidated data for 3 years based. This view has various dimensions and summarized metric values like net sales, net sales LY, qunatity, quantity ly. Now the report that i am asked to create is dynamic selection criteria for rows and columns which act as group by for the facts that need to shown. It will be really helpful if you can provide me with the PBIX that you created just so i can recreate the same stuff and work on the fact bit. Thanks in advance
