Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Counting data per day if data rows are date/time format

Hi, I am just starting to use Power BI and currently, I am trying to generate a graph of user logins. My data sample looks like:

 

ServerDateUser
ServerA10/9/2019 12:24User A
ServerA10/9/2019 14:16User A
ServerA10/11/2019 8:44User B
ServerA10/11/2019 13:54User C
ServerB10/9/2019 14:35User D
ServerA10/18/2019 16:55User B
ServerA10/18/2019 17:41User C
ServerA10/21/2019 12:05User D
ServerB10/24/2019 8:23User C
ServerB10/24/2019 9:30User C
ServerB10/24/2019 13:22User C
ServerB10/24/2019 17:52User C

 

I would like to create a bar graph, based on filtered date, showing how many users logged in per day. I have tried to create a date dimension table and created a relationship with my data table, but I can't seem to just show the graph that I would like to have. Do I need to create a measure to get what I would like to do? Unfortunately, I have not used DAX yet, and hopefully, I will be able to learn that as well in the future. 

 

Hoping somebody can show me how I can do this. TIA!

Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Could you please let me know if you'd like to get this one?

    1. I changed your date/time column as Date in power query:

    2. Add the measure :

    Measure = CALCULATE(DISTINCTCOUNT(Table1[User]),ALL(Table1),VALUES(Table1[Date]))

    3. Create the visual:

     

    Pbix attached.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for the tip! What I did was similar to this, creating a new column with just the date, no timing. I was finally able to achieve what I wanted.

7 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Could you please let me know if you'd like to get this one?

    1. I changed your date/time column as Date in power query:

    2. Add the measure :

    Measure = CALCULATE(DISTINCTCOUNT(Table1[User]),ALL(Table1),VALUES(Table1[Date]))

    3. Create the visual:

     

    Pbix attached.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the tip! What I did was similar to this, creating a new column with just the date, no timing. I was finally able to achieve what I wanted.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi nahid3152,

       

      Thanks for sharing some thoughts on this and sharing your sample file. Unfortunately, I am unable to share online files due to org's security policy. However, I am attaching an Excel graph which is what I want to have in Power BI. 

       

      The file you shared is not what I was looking for. 

       

      My target graph

       

      Any thoughts on how to do this in Power BI?