Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
108 | |
95 | |
83 | |
77 |