dynamic table using column name as a slicer selection

Question

I am wondering if it is possible to do so, is it possible to create dynamic table using column name as a slicer ?
Thanks in advance!

Answer 1

No it's not. Your question kind of implies that you are probably dealing with a pivoted data set. Maybe something with a column for each month of data and you want to slice by month. If this is the case the answer is to unpivot your data.

So instead of a table like this:

Product Jan Feb Mar 
A          10   11  12

You end up with one like this:

Product Month Amount
A           Jan     10
A           Feb     11 
A           Mar     12

Then you simply create a slicer on the month column. Power Query has a specific unpivot transformation that will do this.

---

http://darren.gosbell.com - please mark correct answers

Answer 2

Hi Bob_Tang,

Thanks for your question.

>>>I am wondering if it is possible to do so, is it possible to create dynamic table using column name as a slicer ?
I agree with Darren, the answer is no. But there is a workaround to achieve this, please refer to below similar thread:
dynamic column based on slicer selection

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 3

Hi wilson,

Thanks very much, this is exactly what I want.