Forum Discussion
How to create a filter to filtering multiple column
Hi there,
How Can I create a filter Like this below
that contain 4 options: (A,B,C,D)
and when I click on A this will show me all data under ClassName with A = 1 or
when I click on B this will show me all data under ClassName with B = 1 and so on ...
| ClassName | A | B | C | D |
| Class A | 1 | 1 | 1 | 0 |
| Class B | 1 | 1 | 0 | 0 |
| Class C | 1 | 0 | 0 | 1 |
| Class D | 0 | 0 | 1 | 0 |
Thank you so much.
2 Replies
VictoriaNguyen here is my solution, there can be a better way to achieve this.
https://1drv.ms/u/s!ArEx6MabNbWogQJireyVlh9d0DI2?e=oEuOJE
Steps:
First I have transposed the data so that I can use Classvalue(A, B, C, D) as a slicer.Second, I have applied a visual level filter on Matrix to get rid of 0 when a slicer value is selected.
Hope it helps.
Hi, thank you so much for your reply but I have more than 10 Columns and it contains more than 1 million rows. It will be complicated for my report.
