Slicer - Cards - 11 SharePoint Lists

[TxSteve]

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!

[TomMartens · Accepted solution]

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-conce... 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/

[darentengmfs]

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.

[TxSteve]

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.