Forum Discussion
Time series as shared axis
Hello Everyone, I'm facing a problem into Power BI and I hope some of you could help me.
I'm trying to do a graph with line and columns like this one:
The problem is a have to choose which date put on X axis. My data set is like the one below:
If I put the Planned dates as the shared x axis, my actual date will appear on the planned date and I would like the actual appears at actual date. I did in Excel to show you how it should appear:
Thank you everyone.
Regards
4 Replies
- mwegener
Most Valuable Professional
Hi Anonymous ,
link all data fields with a date table.
Create a measure for each date and activate the corresponding relationship with USERELATIONSHIP.
Place the date table on the axis.https://docs.microsoft.com/en-us/dax/userelationship-function-dax
If you provide some sample data, I can build an example for you.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.Hi mwegener ,
First of all, thank you very much repplying me.
I'm sharing with you one data set that I'm trying to do this kind of graph without success. (https://1drv.ms/x/s!Am9o_aLPkoYukuMziXNWkZLDwIkTJw?e=8btMoA)
I appreciate all help or any kind of tip toward the solution.
Thanks
Regards