Forum Discussion

raman_vee's avatar
raman_vee
Regular Visitor
3 years ago

Combining Multiple Measures into 1 Line Chart

Hi,

 

I have some measures that I made to read data from a SharePoint List and I want to compare them to metadata that I have from a SharePoint Document Library. Basically, I want to do some file tracking based on a plan.

 

I am almost there but struggling at the finish line.

 

I want to have a stacked bar chart showing the actual documents and a target line which is the planned list of documents expected. I have created some measures to get the data points that I need for the line chart, but it looks like below. I drew in Green what I want this to look like. The 3 and 2 value are being driven by 2 quick measures that I made to filter the plan data from my sharepoint list.

 

So my SharePoint List would expect 2 documents, but I have 8 documents there (above target) gives a sense that we are storing the key auditable documents that we need to vs. going to check all the folders and constantly bug the team.

 

Any help would be appreciated !

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    raman_vee Perhaps just use a Stacked column visual and add your lines as Constant lines using the Analytics pane. You can tie the constant lines to a measure.

    • raman_vee's avatar
      raman_vee
      Regular Visitor
      3 years ago

      Hi,

       

      Thanks for the quick response. I tried that but does not get me where I need to be. Also I want these the automatically update as the data changes.

       

      Ideally, these measures would populate into a column on a table somewhere and then I could add that as the line information on the combination chart. Also not sure if that's the best way either.