Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
Solved! Go to 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.
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.
Hello,
It was as simple as that ! Thanks a lot !
You are welcome.
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 !
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |