Select a column in a table with a slicer

[ngn_marie05]

Hi everyone, 

It sounds silly, but I have been looking on many forums and I can't find the answer.

I have a table with many columns: Delivery Date, Order Date, Delivery Hour, Order Hour, Turnover... 

I would like to create a simple bar chat with the hour in X Axis and use the turnover as a value. But it would depend on the selected value: Delivery or Order. 

I tried to create a measure by using "Switch", to add a column... but it doesn't work. Or maybe I'm doing it in the wrong way.

Thank you so much for your help! 

[amitchandak · Accepted solution]

@ngn_marie05 , Create field parameter on both dates and use that on axis

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

Option two, Join both of them with the same date table and you will have inactive join. Create a measure using userelationship to active the join - refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Create two measures and then again use field parameter to switch measure but axis will fixed, date table's date

[ngn_marie05]

Thank you very much for your help!!