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

Filter Table Dynamically

Hi,

 

I need to filter a table "Filtered Output" when i click on one of blocks(it's card).

If i click on Block( "Doing/ Incidents") the filtered output must have only one record. The area "1" and "Filtered Output" needs to be filtered by value selected on slicer "Assignment Group".

How can i accomplished this?

 

sample.png

Best Regards,

Bruno Roque

 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @brunoemr,

 

To what I can understand your section 1 is composed by Cards visual correct?

 

Using Card visuals you can't filter out other visuals since Cards only have one value, Why don't you replace your visual from cards to a Table, and then you can filter the final table.

 

Using the conditional formatting on table you can make the colours on the columns, for this you need to have an additional table with colours for each of your status (Todo, Doing,..)

 

Check PBIX file, this setup is not as yours for sure, but if you give some sample data I can make a example with your data.

 

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



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @brunoemr,

 

To what I can understand your section 1 is composed by Cards visual correct?

 

Using Card visuals you can't filter out other visuals since Cards only have one value, Why don't you replace your visual from cards to a Table, and then you can filter the final table.

 

Using the conditional formatting on table you can make the colours on the columns, for this you need to have an additional table with colours for each of your status (Todo, Doing,..)

 

Check PBIX file, this setup is not as yours for sure, but if you give some sample data I can make a example with your data.

 

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



View solution in original post

brunoemr
Frequent Visitor

Hi,

 

Thanks, I will try to do using your example @MFelix 🙂 

 

Thanks in advance,

Bruno R.

Hi @brunoemr

Could you kindly accept MFelix's reply as a solution if it really helps you?

If not, don't hesiate to ask here.

 

Best Regards

Maggie

vinaypugalia
Resolver I
Resolver I

You can easily achieve this out-of-box by setting up the right table relationships. Hence, if you can share your data model, that will really help us to assist you further.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.