Forum Discussion
Create a New Filter
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
Hi Anonymous ,
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
4 Replies
Hi Anonymous
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.
Ok. I might have misunderstood what you're trying to achieve. Can you please elaborate your use case?
Hi Anonymous ,
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
