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.
Hi There,
I'm very new to power BI and DAX, so apologies if this a silly question.
Basically the data set I'm using has the itemisation on the left hand side, and a number of measures going across the top.
I can easily update the table by manually dragging which column measure I want to display in a table, but it would be nice if you could do this by selecting which measure you want displayed in the table from a filter list.
So ideally the smart filer would list each measure column, and once selected the table would automatically update the values from the selected measure.
I hope this makes sense. I appreciate any help you can offer.
Many thanks,
Ashley
Solved! Go to Solution.
Hi welcome to the forum. Perhaps you need to reshape the data a little. Go to the query editor (Home / Edit Queries), select all the columns with the measures and click on Transform in the ribbon then unpivot columns.
>> If its a solution please mark as such
Hi welcome to the forum. Perhaps you need to reshape the data a little. Go to the query editor (Home / Edit Queries), select all the columns with the measures and click on Transform in the ribbon then unpivot columns.
>> If its a solution please mark as such
Worked perfectly! Thank you for the help!
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 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |