dynamically filter table depending on column value

[yhajji]

Hello,

I'm trying to show a reporting composed of two points :

1. a graph showing the number of persons that assisted to a course. In the same graph I show the number of persons that should assist to the course.

I use two measures based on the value of a column (Assisted/have to assist) to calculate both values.

On a table, I'd like to show the names, surnames and "attributes" of these people. Also, depending on the value of the previuous graph : If i click on one measure, the table should show only those who a related to the measure I clicked on.

My problem is the following : 

At this point, I'm capable of showing the whole table, however I searched for a way to dynamically fiter depending on the but I still can't find any answer.

Do you have any idea please ?

Thanks in advance !

[Ashish_Mathur · Accepted solution]

Hi,

Create a slicer and drag the column which has Assisted/have to assist column there.  When you click on Assisted, the table should only show those relevant rows.

[yhajji]

Hello, 

It was as simple as that ! Thanks a lot !

[Ashish_Mathur]

You are welcome.

[yhajji]

Hello,

I'm trying to show a reporting composed of two points :

1. a graph showing the number of persons that assisted to a course. In the same graph I show the number of persons that should assist to the course.

I use two measures based on the value of a column (Assisted/have to assist) to calculate both values.

On a table, I'd like to show the names, surnames and "attributes" of these people. Also, depending on the value of the previuous graph : If i click on one measure, the table should show only those who a related to the measure I clicked on.

My problem is the following : 

At this point, I'm capable of showing the whole table, however I searched for a way to dynamically fiter depending on the but I still can't find any answer.

Do you have any idea please ?

Thanks in advance !