How to draw a Stacked bar chart for multiple date columns with respect to their count

[vinaymotamarri]

From the below data, First row is Header column, Now I need a stacked bar chart, that shows number of First_call, Second_call, Third_call together as a total bar length and then each partitioned by different legends for each date on x-axis, Thanks In advance

First_call	Second_Call	Third_Call
1/1/2018	1/2/2018	1/3/2018
1/2/2018	1/4/2018
1/3/2018

[vinaymotamarri · Accepted solution]

    I Figured out solution myself, by creating a Rolling date and three independent tables for all the 3 columns in power BI and then establishing one to many relations between rolling date table and the rest of the 3 tables

[annaY]

Congrats for figuring it out! Could you share your step by step for folks coming to look at your post and wanting an actual solution?

[Anonymous]

Hi @vinaymotamarri

Is it the one you are looking for?

 

Thanks

Raj

[vinaymotamarri]

Hi Raj,

   Thanks for your response, but i am looking for the stacked bar on each date that are present in given data but not as whole, so i needed dates on x-axis with their corresponsing count on y-axis

Below is the kind of output i am looking for :

Thanks

Vinay