X- axis based on the selected date

[Anonymous]

Hi experts,

Need your help here.

We have two dates in our dataset, say Order Date and Sales date. Based on the User, we want to change the X-axis of a bar graph. If user wants to see data based on the Sales Date, then X- axis should show sales date and if selected value id Order date, then X- axis should show Order date 

Thanks

[amitchandak]

@Anonymous , you have to create a common date table and join both dates with then and then have measures that use date using userelation, a post that you can have measure slicer

Use relation example: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME

In case you change axis not date in measure

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

[Anonymous]

Hi @amitchandak . Thanks for your response.

This is the data model we have 

and the expected output is 

Please advise. Thanks

[Greg_Deckler]

@Anonymous - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444

[Anonymous]

Thanks @Greg_Deckler  for your reply.

In our case we have two date dimensions. one is for Sales date and other if Order date.

What i am trying ...

I have created a table like 

Then used the 'Select date' column in the slicer and trying to write a DAX logic like- 

SelectedDate = IF(SELECTEDVALUE('Date Selection'[Select date]) = 1, Sales Date[Date], Order Date[Date])

But it is not allowing me to use Sale Date[Date] and Order Date[Date] in the DAX.

Any idea??

[Greg_Deckler]

@Anonymous - Well if that is a measure and you are referring to a column, you need to use an aggregation like MAX, MIN, etc. But, to use a measure in that way you generally need to use a disconnected table. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563

[Anonymous]

Thanks @Greg_Deckler  for a quick reply.

In my case, Sale Date[Date] and Order Date[Date] are two date type columns. 

So can not apply any aggregate function.