Forum Discussion
Dynamically filter table based on slicer
Hello, I am trying to dinamically filter a table visualization based on a slicer. I have a data table like the one below: Date Attribute 1 Attribute 2 01/01/2010 A red 01/02/20...
vanessafvg Yes here is an example:
If I click on red, then this will be the output:
| Date | Attribute 1 | Attribute 2 |
| 01/01/2010 | A | red |
| 01/02/2010 | B | red |
| 01/03/2010 | C | red |
| 01/04/2010 | D | red |
If I select green, this will be the output:
| Date | Attribute 1 | Attribute 2 |
| 01/08/2010 | A | green |
| 01/09/2010 | B | green |
| 01/10/2010 | C | green |
hi Anonymous
You could just create a table visual that contains these three columns and a slicer that used Attribute 2.
Result:
and here is sample pbix file, please try it.
Regards,
Lin