Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |