Dynamically filter table based on slicer

[Anonymous]

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.

[ammcleod]

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? 

[Anonymous]

I don't understand your question. This is a simple table visual. If you add a slicer with that dimension, the rows in the visual will show only those rows. 

[EricHulshof]

Heya,

You can just put Attribute 2 in a slicer and select the color you'd like. The table should automaticly pick up and show only the red rows.

[vanessafvg]

@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?

[Anonymous]

@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

[v-lili6-msft]

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

[vanessafvg]

@Anonymous  what is the code for the measure?

im a little confused why can't this be achieved with a slicer?