Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |