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
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
Thanks for your help....It is working now.:smileyhappy :)