How to set up 2+ line charts with one filtering field parameter slicer?

[Anonymous]

Hi, 

I have about 15 graphs, and they all have different values but each table contains the same column names and row names. I just need to create a slicer that will dynamically change all of them at the same time depending on which option is selected. I am very new to power BI but I habe not been able to find any video or post that does what I am looking to do. 

Thanks for the help!

[Anonymous]

Hi @Anonymous ,

By reading the documentation provided by Ryan, we can know that the "1" side of the relationship can filter the "*" side. We can create a table on the "1" side through a function.

Based on your description, you can use some functions to create a new table with a single column and use this column to create relationships with other tables, and finally use this column in the slicer as well.

Function:

Difference between DISTINCT and VALUES in DAX - SQLBI

Best practices using SUMMARIZE and ADDCOLUMNS

Introducing SUMMARIZECOLUMNS

If this doesn't solve the problem or I misunderstand your needs, please feel free to let me know.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[ryan_mayu]

@Anonymous 

you can create a dimension table and create one to many relationships with each table.

Model relationships in Power BI Desktop - Power BI | Microsoft Docs