Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have the following data:
Created Date
Invoiced Date
Region
I want to chart out somethng like
---------------------------------------created date
---------------------------------------Invoice Date
Region
In a line chart. Can this be done?
Cant figure out how to bring in the data
The lines will fluctuate depending on days between invoice date and created date.
Solved! Go to Solution.
@Rocky_Brown , With a common date table, You can create measures that work on create date and Invoice date. Use userelationship for inactive dates
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @Rocky_Brown
You can calculate the diff between two dates .
Region = DATEDIFF(SELECTEDVALUE('Table'[Created Date]),SELECTEDVALUE('Table'[Invoiced Date]),DAY)
Then add a line chart , use [name] as Axis ,[region] as value .
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Rocky_Brown
You can calculate the diff between two dates .
Region = DATEDIFF(SELECTEDVALUE('Table'[Created Date]),SELECTEDVALUE('Table'[Invoiced Date]),DAY)
Then add a line chart , use [name] as Axis ,[region] as value .
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Rocky_Brown , With a common date table, You can create measures that work on create date and Invoice date. Use userelationship for inactive dates
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |