Create a New Filter

[GAPER]

Here is my data structure

#	is_a	is_b	is_c
1	v	v
2		v
3			v
4		v	v
5		v

I want to create a filter which category and people can choose 

filter

is_a

is_b

is_c

Thanks

[Anonymous · Accepted solution]

Hi @GAPER ,

If I understand correctly, the issue is that you want to create a new filter and choose category. Please try the following methods and check if they can solve your problem:

1.Drag the field into the filters pane.

2.In the filters pane, you can choose basic filtering or advanced filtering to define more complex filter criteria.

3.Once configured the filter, it will automatically be applied to all the visuals on the current report page.

Looking forward to your reply.

Best Regards,

Wisdom Wu

[GAPER]

In this case aren't your duplicating the values in aggregrations?

[danextian]

Ok. I might have misunderstood what you're trying to achieve. Can you please elaborate your use case?

[danextian]

Hi @GAPER 

Unpivot all other columns except the first one so the column headers become part of the rows and you can use the column they are in to filter your data. Please see attached sample pbix.