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.
Hi,
I have a requirement as "I have 10 rooms as Room A, Room B, Room C etc., based on the time a person in a room, I need to calculate the time that he spent in one room and show this data in a visual as order by the time he entered into the room". I tried to bring this in pie/donut chart but it is not working. When I say not working it is actually grouping based on the room. If a person enters Room A and spent 10 mins first and then Room B spent 2 mins and then Room C spent a min and then again the went back to Room A and spent 5 mins and then went to Room D and spent 15 mins, the chart should show in this order instead of showing the total time spent in Room A and Room B and Room C.
Location | TimeEntered | Timespent in mins |
Room A | 23-03-18 11:03 | 8 |
Room B | 23-03-18 11:11 | 1 |
Room C | 23-03-18 11:12 | 2 |
Room D | 23-03-18 11:14 | 1 |
Room E | 23-03-18 11:15 | 5 |
Room B | 23-03-18 11:20 | 6 |
Room A | 23-03-18 11:26 | 10 |
Room C | 23-03-18 11:36 | 5 |
Room B | 23-03-18 11:41 | 8 |
Room F | 23-03-18 11:49 | 3 |
Room G | 23-03-18 11:52 | 1 |
like this, it is grouping one area irrespective of time order and room.
I want something like this in order and Room should show in single color
Can someone please help me to get this? Also please suggest if any other will suit for my requirement.
Thanks
Akhil
Solved! Go to Solution.
@Anonymous
See the file attached file with your sample data
First add these calculated columns in your Table
New Location = Table1[Location] & Table1[TimeEntered]
RANK = RANKX ( Table1, Table1[TimeEntered],, ASC, DENSE )
Hi @Anonymous
Now drag the New location and RANK fields to LEGEND
and Timespent in minutes to VALUES
AND RANK to Tooltips
Now sort by RANK Column
Well, perhaps you could create a new column that concatenates Location and Time Entered and then try to set the Sort By on this new column to Time Entered. You would probably have to do that concatenation in the query however to avoid a circular reference. That being said, I have no idea if a pie chart has any concept of sorting.
@Anonymous
See the file attached file with your sample data
First add these calculated columns in your Table
New Location = Table1[Location] & Table1[TimeEntered]
RANK = RANKX ( Table1, Table1[TimeEntered],, ASC, DENSE )
Hi @Anonymous
Now drag the New location and RANK fields to LEGEND
and Timespent in minutes to VALUES
AND RANK to Tooltips
Now sort by RANK Column
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |