Forum Discussion
Get Full SharePoint List Column Entries
Hi all, I have a SharePoint choice column I want to use for reporting. I need to count actual vs possible for that column. How do I get the values for the possible choices through Power BI without c...
llhanley,
Please expand the choice column in Power BI Desktop following the guide in the blog below, then calculate your expected count values based on the data.
https://whitepages.unlimitedviz.com/2018/01/using-power-bi-to-report-on-multi-value-sharepoint-fields/
Regards,
Lydia
I have a different issue. I'll put a new message together that better describes what I am looking for. Thank you!