Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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
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
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?
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |