How to - Cascading customized date filter on Power BI

Hi Randcharles ,
Based on your description, you want to create parameters to display different columns as slicers. If measure is used based on the selected parameters, the slicer does not support measure. If you force the parameter to use other fields, the slicer will not display the column in its entirety.
So, there are two ways you can do this:
First, you can use the unpviot three columns to make the column names in the same column, so that you can build a slicer with the two columns after unpviot.

In the second way, you can continue to use the parameters, and in the second you can replace the slicer with a table and put the parameters into the table visualization. After that, you can click on the data on the table to filter
it

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Anonymous ,

Thanks a lot for your help and advice. 
It works for me. I have used the first option by using parameter with unpivot columns.
Great idea!