Forum Discussion
Creating a Single Slicer for Multiple Column
ankitkagarwal88,
1. Unpivot your columns of Table 1 and Table 2 in Query Editor of Power BI Desktop.
2. Rename Attribute column in Table 1 and Table 2 to Month.
3. Create a new table using DAX below.
Table = DISTINCT(SELECTCOLUMNS('Table 1',"Month", 'Table 1'[Month]))
4. Create relationship using Month field among the three tables.
5. Create slicer using the Month field of the new table, then you are able to use the slicer to filter your visuals.
Regards,
Lydia
Hello,
If you create a relationship between the tables, filters will work on both.
Alternatively you can create a new date table and link them both to your new table.
Then you use that data for filtering purposes.
Use this link for more information about a date table:
https://kohera.be/nl/blog/business-intelligence-nl/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/
Good luck