Forum Discussion
Slicers
How do I get multiple slicers to be effective across multiple data sources?
I have 5 data sheets (feeding from Excel)
5 pages which each look at an individual data sheet
A header page which I want to draw data from all 5 sheets
Each of my 5 data sheets share 6 common headings and I have joined these using "Manage Relationships" - but I can only link one column
Is it possible to link the 6 columns which have the common fields I want to sort by?
Help! 😞
2 Replies
- Idrissshatila
Super User
Hello Anonymous ,
you could convert your model into a starschema and use the dimension tables to filter using slicers.
please refer to this document for instruction https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
