cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Linked dashboard controls

I'm building my first dashboard.  I have two controls on it: Account Category and Accounts.  When I select an acct cat I DO want the account list to reflect only those accounts which are in the selected category.  But when I choose an account I DON'T want it to filter the acct cat list.  Can the link function in only one direction?

 

Thanks, Randy Madden

1 ACCEPTED SOLUTION
Microsoft
Microsoft

If by "dashboard" you mean a report or pbix file, and by "controls" you mean slicers, then yes this is possible.

 

Simply select the slicer "Accout Category", then click on the Format tab > Edit Interactions

 

This will bring up some icons for all the visuals on the page (a filter, highlight or strikethrough).  Selecting the strikethrough on the Account slicer will mean that any actions on the Account Category slicer will not filter the Account slicer.

 

Please confirm that this is what you were looking for.

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

If by "dashboard" you mean a report or pbix file, and by "controls" you mean slicers, then yes this is possible.

 

Simply select the slicer "Accout Category", then click on the Format tab > Edit Interactions

 

This will bring up some icons for all the visuals on the page (a filter, highlight or strikethrough).  Selecting the strikethrough on the Account slicer will mean that any actions on the Account Category slicer will not filter the Account slicer.

 

Please confirm that this is what you were looking for.

View solution in original post

dkay,

 

Thank you so much!  It was just the opposite actually - I wanted the Account Category to remain intact; but your description was spot on.  I never knew that existed.

 

Thanks again, Rm

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors