Forum Discussion

yhajji's avatar
yhajji
Frequent Visitor
8 years ago
Solved

dynamically filter table depending on column value

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 !

  • 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.

4 Replies

  • yhajji's avatar
    yhajji
    Frequent Visitor

    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 !

  • 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.