Filter Table Dynamically

[brunoemr]

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?

Best Regards,

Bruno Roque

[MFelix · Accepted solution]

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

[brunoemr]

Hi,

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

Thanks in advance,

Bruno R.

[v-juanli-msft]

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]

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.