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 ...
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.
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.