Forum Discussion

julien-rivley's avatar
julien-rivley
Helper I
6 years ago
Solved

Multi Dimension Visual with Dates

Hello,

 

I have a simple table:

Product,Date,Qty,Category

I would like to create the below chart with:
color=category

size=qty (I can skip the size, the qty in tooltip would be fine)


I tried to use the scatter chart but it doesn't let me put the product field in the Y Axis.
(I guess, a number is expected)

Would you know any way to do that visual?

 

Thanks for you help,

Julien

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

    Hi julien-rivley ,

     

    Maybe you can try the custom visual named SandDance. It allows text type on Y axis.

     

     

     

     

    If you have any question, please kindly ask here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

9 Replies

    • julien-rivley's avatar
      julien-rivley
      Helper I
      6 years ago

      Hi,

       

      Thanks for your help, as I have 500 products, I'm planning to filter them with some product criterias. In this case, the chart could be big if filter only product 1 and product 450, right?

       

      Julien

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        Scatterplot will automatically group patterns if the chart area becomes too busy.

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

    Hi julien-rivley ,

     

    Sorry for that the fields you're using for the X Axis and Y Axis both need to be numeric types, and you need to add a value column to Product column.

    Ibenlin’s answer is the only solution now, and there is no custom visual that meets the scenario.

    If you have any question, please ask kindly here and we will try to resolve it.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • julien-rivley's avatar
      julien-rivley
      Helper I
      6 years ago

      Thanks for your help.

       

      I tried to add the product index as recommended by lbendlin but due to the high number of products, it doesn't look very good if I'm displaying product 3,50 and 250 at the same time.
      Though by using the same method for the date, found a compromise:
      - I changed the date into a +/- number of day VS today and I put them in Yaxis with a fixed line on Today

      - I put the product in X-axis

      - I put the exact date in tooltip

      (The purpose is to show the delivery plan/actuals of products, the color being the status of the procurement)

      Would you have any plan to enhance this visual to allow non numerical data on the Y Axis?

       

      Julien

       

      • julien-rivley's avatar
        julien-rivley
        Helper I
        6 years ago

        Actually, what I mentionned earlier doesn't work, if 2 items are in the same category with different date, the visual is doing the sum of the +/- number of day VS today.

         

        Any ideas?

         

        Thanks!

        Julien