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/2010 | B | red |
| 01/03/2010 | C | red |
| 01/04/2010 | D | red |
| 01/05/2010 | A | blue |
| 01/06/2010 | B | blue |
| 01/07/2010 | C | blue |
| 01/08/2010 | A | green |
| 01/09/2010 | B | green |
| 01/10/2010 | C | green |
The slicer has red, blue, and green as choices, and when clicking one of them, the table visualization should only show the rows corresponding to that choice.
I have created a slicer which outputs into a measure, however I can't find a way to link that into a filter for a table visualization. I've seen similar posts on the forum but they all seem to relate to calculating summaries based on a slicer, creating a measure which uses the SWITCH function , but here I don't need a summary eg. a sum, but I need all the values to show.
Any help or suggestion would be greatly appreciated.
7 Replies
- vanessafvg
Community Champion
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 - vanessafvg
Anonymous what is the code for the measure?
im a little confused why can't this be achieved with a slicer?
Hello Anonymous ,
I'm not sure what you're asking for here, sorry!
You want the Slicer to filter the table based on an option chosen from a measure?You can look into SELECTEDVALUE
https://docs.microsoft.com/en-us/dax/selectedvalue-function
Without more information I can't specifically help you, can you show me the measure you have?
