Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please help on this:
I have a table (data source) with columns:
C1, C2, C3, C4, M1, M2, M3 etc.
Now I have to create a matrix where users can choose using a slicer what goes in rows or colum or value. Say:
C2 | |
C1 | M1 |
or
C1 | |
C3 | M2 |
Solved! Go to Solution.
Hi @RainyDays ,
For swithching columns in Matrix, you could reference the links to have a try.
Reference:
https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/td-p/687993
Power BI - Dynamic Columns in a Table
Currently, it is not supported to drag measures into Row field. So we can't change them directly. You could reference the blog to use Bookmarks or pivot table to have a try.
4 different ways to dynamically change table’s rows in Power BI
Hi !
Seems like you are trying to complicate the things, Power BI is a self service tool, just connect the PBI Desktop file with your data model & let user drag & drop columns into rows & columns.
Nothing to worry about, only expose selected columns.
Regards,
I have to finally publish this report to Power BI online. Users are not using desktop version....also this is part of a migration project from Tableau so my goal is not to take away any functionality they used to have in Tableau.
Hi @RainyDays ,
For swithching columns in Matrix, you could reference the links to have a try.
Reference:
https://community.powerbi.com/t5/Desktop/Dynamic-column-selection-for-matrix-visual/td-p/687993
Power BI - Dynamic Columns in a Table
Currently, it is not supported to drag measures into Row field. So we can't change them directly. You could reference the blog to use Bookmarks or pivot table to have a try.
4 different ways to dynamically change table’s rows in Power BI
Hi @RainyDays ,
Is the answer helpful? If yes, please accept it as a solution. Then others who have the same requirement will benefit from this thread.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |