Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
82 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |