Forum Discussion
Slicer - Cards - 11 SharePoint Lists
Hey TxSteve ,
I recommend to make one table from the ten using Append. This article https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/ provides further information.
You just have to make sure that each list has a column that sets the Sharepoint lists apart. Create a column called team if necessary and add a constant value, then merge all the tables (10 Sharepoint lists) into one.
Hopefully, this provides some new ideas.
Regards,
Tom
Next: I recommend following this introduction to Power BI data modeling - https://docs.microsoft.com/en-us/learn/paths/model-power-bi/
Post ProdigyHi TxSteve
Have you determined the relationship between all the tables to the Master table? You have to specify the relationships with primary and foreign key for the slicer to work.
I selected Manage Relationships and it appeared to join my tables (SharePoint Lists) but I still get no changes when I try to slice a Month.