Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kpk122
Frequent Visitor

Dynamically set slicer using selected table row

Is it possible to dynamically set a slicer, based on a given field in a table row, when a row is selected?

 

I work for a commercial lender and we've built a multi-page Power BI report evaluating several aspects of our borrower relationships, as defined at a MasterAccount level.  All tabs are primarily driven off of a single slicer on MasterAccount.  This works perfectly mechanically, but in practice we have three difficulties finding the right one: a) there are thousands of accounts, b) many really are distinct but sound similar, and c) we often need to search by individual without knowing what MasterAccount they roll up to.

MainSlicerMainSlicer

 

To facilitate searching for the correct MasterAccount, we built a table (searchable via Text Filter) listing all active individuals & companies, the capacity in which we work with them, the MasterAccount they're associated with, and the value of the relationship at that MasterAccount level.  Therefore, the same MasterAccount can appear multiple times (in red), with the most probable hits at the top.

SearchAssistant.jpg

 

This requires a 2-step process.  Ideally, I'd like to be able to click on an entry in the table and have it populate the slicer for the selected MasterAccount.  (For the record I do NOT want to use the whole row and filter for the individual/company too, as several entries can roll up to the MasterAccount).

 

I'm relatively new to Power BI and don't know how to do this without access to VBA.  I searched and couldn't find other threads on this.

 

Thanks for your assistance!

 

 

6 REPLIES 6
kpk122
Frequent Visitor

Thanks for the response MFelix. I do want only the MainAccount to act as the slicer / field used to filter reportS. For example, if Person A and Person B both work for XYZ Corp, If I search for Person A I want it to show that they work for XYZ Corp in the lookup table, and if I select the line with Person A I want the reports to be oriented around all of XYZ Corp.

Thanks again!

Hi @kpk122 ,

 

I would do this with two slicers with the search option turn on. Another thing I would do is to make the slicer with the names only have interaction with slicer with the accoutns and the slicer with the accounts would have interaction with all visuals.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



kpk122
Frequent Visitor

That's a really cool idea @MFelix and I'm sure I'll use it in the future, but if I approach this situation that way I'll lose the ability to show descriptive info, correct?

 

Happy New Year all.

Hi @kpk122 ,

 

What do you mean by descriptive info? Are you refering to the information that you have on the overall table you are using to select the users?

 

If that is the case then you just need to make the table visual interact with the name slicer and without interaction with the other slicer, that way the table would still work as you wish but without the need for the users to click on it.

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



HI @kpk122 

I'm a little confused about your description, could you please use some simple dummy data show your expected output.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MFelix
Super User
Super User

Hi @kpk122 ,

 

First of all you need to understand that slicers are using for filtering data meaning that the interactions with the rest of the visualizations is different from the other visuals. Since slicer are used for filtering data when you select one value in the slicer the data in the other visuals is change accordingly ro your selection however the interaction from other visuals to slicer is not done except if you use another slicer.

 

So if you have a table visual and you select a value all visuals are filter by that value except the slicers if on other hand you select a value on a slicer other visuals including slicers will be filter.

 

On you case believe that the best option is to use the Hierarchy Slicer making the use of both the columns Full Name and account also make sure you activate the search option

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

 

I'm assuming that you want to select the user but also the account didn't understood if you also want to have only the selection of the main account for all users.

 

Regards,

MFelix

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors