Dynamically Filter Visual

[newpbiuser01]

Hello,

I have a report with a slicer, and I'd like to dynamically filter the visuals based on the dropdown value selected. So as an example, my table looks like the following:

ID	Vendor	Status	Cost	Date
123	ABC	Active	10	10/02/2020
232	BCD	Deleted	20	23/04/2021
434	CDE	Pending	10	30/11/2019
545	DEF	Draft	2	09/09/2019
123	EFG	Active	30	10/05/2020
434	FGH	Approval	40	01/01/2021
123	GHI	Draft	31	02/06/2021

For my Status filter/slicer, I have the following options:

Active

All

Pending

Valid

In my report, I have a bar chart and a table visual below that. I'd like to filter the visuals as follows:

1. Active - show all except deleted, draft or pending

2. Valid - all except deleted

3. All - not draft

4. Pending - pending

I can't use the summarize function the table visual is not a summary table but a drilldown view. Does anyone know how I can do this? I'd really appreciate any help! 

[Anonymous · Accepted solution]

Hi  @newpbiuser01 ,

Here are the steps you can follow：

1. Enter data -- TABLE.

2. Create measure.

Flag =
var _select=SELECTEDVALUE('Slicer_Table'[Slicer])
return
SWITCH(
    TRUE(),
    _select ="Active"&& NOT(MAX('Table'[Status])) in {"Deleted","Draft","Pending"},1,
    _select ="Valid"&& MAX('Table'[Status]) <> "Deleted",1,
    _select ="All"&& MAX('Table'[Status]) <> "Draft",1,
   _select ="Pending"&& MAX('Table'[Status]) = "Pending",1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

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

[newpbiuser01]

Thanks @Anonymous!