Forum Discussion
Plotting 2 dates from same table onto line chart
HI graemejones ,
You not need to modify your database, my suggestion do these operations on data model side.(create a calculated table to expand original date range)
Steps:
1. Use unique fields and two date fields to create a calculate table with expand records.
2. Create relationship between raw table and calculate table based on above unique field.
3. Use new table date field as axis, raw table amount fields as value to create visuals.Regards,
Xiaoxin Sheng
HI graemejones ,
You not need to modify your database, my suggestion do these operations on data model side.(create a calculated table to expand original date range)
Steps:
1. Use unique fields and two date fields to create a calculate table with expand records.
2. Create relationship between raw table and calculate table based on above unique field.
3. Use new table date field as axis, raw table amount fields as value to create visuals.
Regards,
Xiaoxin Sheng
Thank you again for your help, I got this working and have now finished my report, which is the next problem. I uploaded my working report to the Power Bi service and it won't work online see below.
Working in Power Bi Desktop:
Working Report
After uploading it looks like this in the workspace:
Not Working Report
Below shows the tables in my Power Bi Desktop (right) and in the online service (left):
How can I fix this?
As always I really appreciate your help.
Graeme
Hi,
I recreated the report from scratch and all is now working, thank you for all your help.
Graeme