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...
Anonymous can you demonstrate using the data what you want to come out with?
are you saying if you click red only red rows should remain?
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 Anonymous what is the code for the measure?
im a little confused why can't this be achieved with a slicer?
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
