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 Community,
It has been really great to be part of powerbi community and I am really thankful for all the help that I get. It has helped me a lot in my project.
There is yet another issue that I have and I am not able to figure out a way to do it.
I need to create a chart like this:
This chart is for number of people attending an online event and I have their unique ids, session id, in time and outtime.
Please help. Thank you in advance.
BR
Sujata
Solved! Go to Solution.
@sujatakaran , see time table can help.
You have to join it with the time part. In case you have two time part , you may have use userelation
Time Part = [Date time].time
Use relation example : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hello, This is resolved.
@amitchandak I took some help from the HR analytics blog and then built on that.
I created a count of active attendees in a given time :
@sujatakaran , see time table can help.
You have to join it with the time part. In case you have two time part , you may have use userelation
Time Part = [Date time].time
Use relation example : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hi @amitchandak
Thank you for your reply.
I created the time table and connected these two tables with time:
Created a measure as per this:
Hello, This is resolved.
@amitchandak I took some help from the HR analytics blog and then built on that.
I created a count of active attendees in a given time :
@sujatakaran , Good that it helped. Kudos to you.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |