Forum Discussion
Slicer
Hello Guys, I may need some help on Slicers in Power BI Desktop. I want to Filter a table by year (2020, 2021 and so on). But some of the rows are assigned to multiple years, e.g. '2020; 2021'...
It sounds like you want to split the column in Power Query (using ; as the separator).
If you choose 'Rows' from the Advanced Section, it'll do what you want.
Let me know how you get on.
It sounds like you want to split the column in Power Query (using ; as the separator).
If you choose 'Rows' from the Advanced Section, it'll do what you want.
Let me know how you get on.