Dynamic Multi-Column Filter based on one parameter

[osindhuw1]

Hi All,

I am looking for assistance to make a dynamic filter in my visual. My data is look like this below picture, basically consists of item code, month, year, and data checker for each departure and arrival, and lastly the quantity.

I am creating 1 parameter called "Parameter month", consisted of Departure (represent month departed column) and Arrival (represent month arrived column). I use it as slicer, so whenever i select Departure, my graph will visualize total quantity based on month departed column, and so do with Arrival. The measure to summarized the total quantity based on the selected slicer is done and the visual works perfectly.

The problem now is, i want to filter only for item departed/arrived (based on slicer) in 2023 and only OK data. So whenever i choose "Departure" in  slicer, my visual will only show all data with Year departed = 2023 and Departure OK = 1, which is the sum of quantity is 20.

Same goes when i choose Arrival slicer, my visual will only show data with Year arrived = 2023 and Arrival OK = 1, with the sum of quantity of 16 (regardless whatever the departure status is)

I tried to create a new parameter year, and put it in the filter, but it seems the filter only show the column name instead of the value of the column, makes filtering not possible. Any advise to create this dynamic filter, without adding any new slicer in the visual page?

[amitchandak]

@osindhuw1 , Join both dates with the same column. There will be one inactive join. You can activate that using userelationship in the measures.

Now you can create a measure and switch them using field parameters of old measure switch method

Userelationship

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Measure Slicer old Way: https://youtu.be/b9352Vxuj-M