Creating stacked bar chart with calendar based data pulled from different queries

[bgirish]

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.

[v-yuezhe-msft · Accepted 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