cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bgirish Frequent Visitor
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.