Forum Discussion

Selwynster's avatar
Selwynster
Helper II
8 years ago

Scatter chart or Clustering chart

Not sure if this is possible, but I would like to place Dates on the x axis with Occurrences of an event on the y axis.

So if the event occurred on that date, it would be marked on the graph by a dot or a 1.

Please point me in the right direction.

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Selwynster,

     

    Hmm, I guess your table contains events with occurrences date range who described by two date column, right?

    If that is a case, power bi not support analysis date range generate by two date columns.

     

    In my opinion, you need a to create expand date table with detail date to create visual. Please refer to below link to know how to do it.

    Spread revenue across period based on start and end date, slice and dase this using different dates


    Regards,

    Xiaoxin Sheng

    • Selwynster's avatar
      Selwynster
      Helper II
      8 years ago

      Hi Anonymous

      Below is a small sample of my very long table.

      I have all the Dates i need in this table. Do i need to split the table out?

      DateEvent
      1/1/2018A
      1/1/2018B
      1/1/2018C
      1/2/2018A
      1/2/2018B
      1/2/2018C
      1/2/2018D
      1/3/2018A
      1/3/2018B
      1/4/2018C
      1/4/2018D
      1/4/2018E
      1/4/2018F
      1/5/2018D

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Selwynster,

         

        Your table not need to be transformed, you can direct use it to achieve your requirement. 

        Drag date to axis and switch to normal date mode, event column to value field with summary mode count.

         

        Notice: scatter chart seems not support to use data column on x-axis.

         

        Regards,

        Xiaoxin Sheng