Forum Discussion
How to control table/matrix date columns with filter?
I'd advise a bit of remodelling in power query so the data's easier for Power BI to work with.
First highlight all the month columns then click Unpivot Columns
The data will now look like this:
Add a Custom Column to have the source
Repeat the same steps for your second table.
Finally, use 'Append Queries' to get a single table with all the data.
Now you can use a matrix, or any other visual that makes sense, to visualise the data and have a slicer on Attribute (you'll probably want to rename that column in Power Query) to filter just selected months
Solution SageI'd advise a bit of remodelling in power query so the data's easier for Power BI to work with.
First highlight all the month columns then click Unpivot Columns
The data will now look like this:
Add a Custom Column to have the source
Repeat the same steps for your second table.
Finally, use 'Append Queries' to get a single table with all the data.
Now you can use a matrix, or any other visual that makes sense, to visualise the data and have a slicer on Attribute (you'll probably want to rename that column in Power Query) to filter just selected months
Thank you Paul what a great solution. I'll just need some more research as the Source columns in both tables are erroring due to a cyclic reference. Not sure why....
Also the Source was just named 'Table' in both queries leaving me no way to identify them. Is there a way of renaming them manually?