Forum Discussion
Using a List and PowerBI for regular progress reporting
Hi - I've been asked by a Moderator to post my question here as sadly the SharePoint Community couldn't come up with any suggestions. 🙂 I have built a list which contains all our major company i...
Instead of creating a column for each quarter, create a column called "Quarter" and populate that as needed. That way you have data that is usable by Power BI, and you don't have the problem of column count creep.
Thanks for the thought here. However we need to be able to see each quarter as a seperate report across all initiatives and just storing it in a single column won't achieve that. 😞
Yes, it will. All you need to do is to place the quarter field in the column well of the matrix visual (for example)
