Forum Discussion
Slicer - Cards - 11 SharePoint Lists
New to Power BI and need a little guidance please
I have 11 SharePoint Lists. (Team A, Team B, Team C...) 10 are identical aside from the table name. I have one master list.
Instead of using a table or matrix, I hand built my page using cards. Each card displays a value from one of the lists. Now I want to add slicers to filter my data. For example a Month Slicer. If I use a slicer from the Master list, it does nothing.
Help!
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/
3 Replies
- TomMartens
Super User
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/
darentengmfsPost Prodigy
Hi 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.
