Forum Discussion
Helper IVChanged X Axis
Hello,
I built this little model to explain my problem.
I have this table:
Which have a relation with DimDate based on Production date
I designed this visual which is automaticly based on Production date
All of this is ok until now,but i need to change the X Axis interval to start from min(Sales date) until the max(Sales date) but still based on the production date and i can't dot it.
in this case the X Axis will start from 01/02/2018 to 15/04/2018, any idea how can i achieve that with DAX,power query,or any other solution ? Thank you
3 Replies
- amitchandak
Super User
FZOU , Axis will be controlled by date for which measure date. You can have a measure that joins with sales date on tooltip and try.
How to create measure on two dates in the same table refer :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
FZOUamitchandak thank you, but sorry i didn't get it how to do it with your solution, could you give me more informations please ?
- Icey
Community Support
Hi FZOU ,
Could you tell me why you want to do this? I don't quite understand.🤔
Why not just replace [Product date] column with [Sales date] column?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
