Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |