Forum Discussion
Need help with Slicers/Filters!!
Hi All,
I need help with slicing/filtering both rows AND columns. I appended a table off economic data for each metro, see sample below:
My goal is to turn it into a report with two slicers, 1) Slice by year, 2) Slice by Metro. Below is an example of what I want my report to look like:
Any help is greatly appreciated!!
Happy Holidays!
Hi Anonymous
You need to unpivot your main table first.
Can you paste the table in text-tabular format, ratehr than on a screen cap, so that the contents can be copied?
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
step1: Select all the year columns in power query and unpivot columns - just save and apply - and then you get what you desired in the Desktop report tab.
2 Replies
- AlB
Community Champion
Hi Anonymous
You need to unpivot your main table first.
Can you paste the table in text-tabular format, ratehr than on a screen cap, so that the contents can be copied?
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
pitcrajHelper I
step1: Select all the year columns in power query and unpivot columns - just save and apply - and then you get what you desired in the Desktop report tab.