Forum Discussion

blazko's avatar
blazko
Icon for Helper III rankHelper III
9 years ago
Solved

gantt like chart, measure help

Hi i want to make Gannt like chart with user activity in time. So I have this table with user id, date, and time of activity, My thought was to change the time to show rough minutes ( zero the second...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi blazko,

     

    Maybe this one:

     

    Measure 2 =
VAR test = DISTINCTCOUNT ( 'data'[time_h:m] ) RETURN IF ( test = 0, 1, 0 )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi blazko,

 

Could you please post a sample here? If it's convenient for you to provide a PBIX file, that would be great. If not, a sample is also good. (tables and their relationship.)

 

Best Regards!

Dale 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi blazko,

     

    Please check it out here: https://1drv.ms/u/s!ArTqPk2pu-Bkb9izproCt0BnlMA

     

    1. I have create a new table "NewMinutes". The old one could lead duplicate values.

    2. The relationship has been changed. One new column has been created for establishing relationship. 

     

    Best Regards!

    Dale

    • blazko's avatar
      blazko
      Icon for Helper III rankHelper III
      9 years ago

      Hi, thanks for reply :)

      But its notwhat i wanted. If theres no action in certain minute, it should appear as blank bar. Not count operations in bins (which anyway I find an interesting feature I didnt know of :)). I want to make Gantt like chart. There should be minutes, one by one.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi blazko,

         

        Maybe we could add a measure to the visual.

        Measure =
VAR test = COUNT ( data[time_h:m] ) RETURN IF ( test = 0, 0, test )

        Try this one please:https://1drv.ms/u/s!ArTqPk2pu-BkcJVvCSwYC_HCPkw

         

         

         

         

         

         

         

         

         

         

         

         

         

        Best Regards!

        Dale