Combining Multiple Measures into 1 Line Chart

[raman_vee]

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 !

[Greg_Deckler]

@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]

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.