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've got two tables with the structure:
1. order_datetime, totalvalue
2. refund_datetime, totalvalue
I want to create a visualisation that shows the total order value, total refund value and net (order-refund) value for each day.
I've already created a date table - which seemed to be a necessary first step, but not sure which direction to go next.
Thanks.
Solved! Go to Solution.
@bgirish,
You can create relationship using date field between date table and each of the above two tables, then drag date field of date table to x-axis of the bar chart, total order value and total refund value to Value section of bar chart.
For the net value, you may need to create measure, please share sample data of your tables for us to test.
Regards,
Lydia
@bgirish,
You can create relationship using date field between date table and each of the above two tables, then drag date field of date table to x-axis of the bar chart, total order value and total refund value to Value section of bar chart.
For the net value, you may need to create measure, please share sample data of your tables for us to test.
Regards,
Lydia
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |