Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |