Forum Discussion
Dynamic Columns via Slicer Selection for Dates
Thank you yulgu. I actually found a way to somewhat do this. Essentially, creating a date table using
Union( SelectColumns("Selections", Column1forDays, "Order", 1, "Category", "Days"), SelectColumns("Selections", Column2forWeeks, "Order", 2, "Category", "Weeks"), etc for months, yearsThen making a primary filter on Category (Days, Weeks, Months, Years from the above).
And a secondary filter on Selections from the above.
The only remaining issue is solving for slicer cross-filtering as once something in the Selection slicer category is selected, it limits the category selections accordingly. I found I can solve this by making the primary filter a table and setting it to ignore the selection slicer via edit interactions. However, that solution isn't very elegant.
Hi Anonymous,
No. As of now, such a requirement is not supported by Power BI.
Best regards,
Yuliana Gu
Thank you yulgu. I actually found a way to somewhat do this. Essentially, creating a date table using
Union(
SelectColumns("Selections", Column1forDays, "Order", 1, "Category", "Days"),
SelectColumns("Selections", Column2forWeeks, "Order", 2, "Category", "Weeks"),
etc for months, years
Then making a primary filter on Category (Days, Weeks, Months, Years from the above).
And a secondary filter on Selections from the above.
The only remaining issue is solving for slicer cross-filtering as once something in the Selection slicer category is selected, it limits the category selections accordingly. I found I can solve this by making the primary filter a table and setting it to ignore the selection slicer via edit interactions. However, that solution isn't very elegant.