Add Column Measure To A Filter List (Smart Filter)

[aburling1989]

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

[samdthompson · Accepted 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

[aburling1989]

Worked perfectly! Thank you for the help!