Dashboard slicers from different queries

[walker8888]

Hi,

I created a dashboard and each dashboard has it's info from different queries that I wrote. I want to know how I can have my slicers on the top be universal to all of the dashboards because they are getting different information from different queries. 

[Ritaf1983 · Accepted solution]

Hi @walker8888 ,

From the image you shared, it looks like your dashboard contains multiple visuals on a single page. Depending on what you're trying to achieve, here are some suggestions:

1. If all the visuals are on the same page:

   • Ensure that your data model has proper relationships between the tables. If the relationships are correctly set up, the slicers at the top should automatically filter all the visuals on the page, as long as you haven’t modified the interactions.
   • Check the visual interactions settings to ensure that the slicers are filtering all the relevant visuals.

2. If your visuals are on different pages:

   • You can use the Sync Slicers feature in Power BI to make slicers work across multiple pages. This allows the slicers to retain the same selections on all dashboards. To enable this, go to the "View" tab in Power BI, select "Sync Slicers," and choose the pages where the slicers should sync.

3. If your visuals come from entirely separate queries without a shared data model:

   • This requires additional details to provide a specific solution. If the queries are completely disconnected, you might need to create a shared table or parameter to tie them together. For example, you could use a shared "Date" table or a common dimension like "Employee Type" or "Cost Center" to allow universal filtering.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous]

JHi, @walker8888 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it hasn't been resolved yet, please share more details about the issue you're having and we'll do our best to help you solve the problem you're having.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @walker8888 ,

From the image you shared, it looks like your dashboard contains multiple visuals on a single page. Depending on what you're trying to achieve, here are some suggestions:

1. If all the visuals are on the same page:

   • Ensure that your data model has proper relationships between the tables. If the relationships are correctly set up, the slicers at the top should automatically filter all the visuals on the page, as long as you haven’t modified the interactions.
   • Check the visual interactions settings to ensure that the slicers are filtering all the relevant visuals.

2. If your visuals are on different pages:

   • You can use the Sync Slicers feature in Power BI to make slicers work across multiple pages. This allows the slicers to retain the same selections on all dashboards. To enable this, go to the "View" tab in Power BI, select "Sync Slicers," and choose the pages where the slicers should sync.

3. If your visuals come from entirely separate queries without a shared data model:

   • This requires additional details to provide a specific solution. If the queries are completely disconnected, you might need to create a shared table or parameter to tie them together. For example, you could use a shared "Date" table or a common dimension like "Employee Type" or "Cost Center" to allow universal filtering.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[walker8888]

Sorry I am new to power BI, where would I find the visual interaction settings? 

[Ritaf1983 · Accepted solution]

HI @walker8888 
That's ok they are here :

And you also use this guide :
https://www.youtube.com/watch?v=5MteQv_h6ck

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.