Forum Discussion

Shea1's avatar
Shea1
Frequent Visitor
4 years ago

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

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

 

6 Replies

    • Shea1's avatar
      Shea1
      Frequent Visitor

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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support

    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.

  • Hi Experts,

    Is this thread still open? Are we still looking for the solution?

    Line and Stacked chart with tbale is good but will not help me as I want to show YTD and current month on a seperate bars.
    Please share if any custom visual is there by now.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User

      Hi,

      Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.