Splitting data for a stacked column & line chart - 3 values from the same column.

[Shea1]

Hi, I am extremely new to PowerBi and offered my hand to do a project for work.

I have got a column called "Datapack status" which only has 3 values which are - "Submitted", "Reviewing" & "Signed off".

The data is stored inside a Dataverse table that is populated through a PowerApp.

I want a chart like the Excel chart I have attached below. I have tried many things but have failed to replicate this. 

I would appreciate any and all help and I am happy to answer any questions.

Thanks

[v-yalanwu-msft]

Hi, @Shea1 ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

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

[v-yalanwu-msft]

Hi， @Shea1 ；

Try to create line and clustered column chart and use legend, if need ,you could create a measure.

If not right, can you share a simple example and the result what you want to output?

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

[amitchandak]

@Shea1 , refer if this custom visual can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview

[Shea1]

@amitchandak It didnt work unfortunately. I think it might be more complex than I first imagined!