Forum Discussion

jbrolland's avatar
jbrolland
Frequent Visitor
5 years ago

How to include closed items in the stacked column chart?

Hello I have the below data   STATUS Opened Year and Month Closed Year and Month DONE 2021-1 2021-1 DONE 2021-1 2021-2 ONGOING 2021-1   DONE 2021-1 2021-2 DONE 2021-1 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

I'd like ot help but i think your data is incomplete.  Shouldn't there be a Customer or Vedor or Project column as well in your dataset?

jbrolland's avatar
jbrolland
Frequent Visitor
5 years ago

Sorry I missed your answer.

Well not really cause this is incidents cases so except incident description (which is different for every single row) there is not much to add.

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    You may download my PBI file from here.  Using the Query Editor, i have been able to transform data to the shape and form you see in the image below.  You should now be able to build your desired visual.