Forum Discussion

julien-rivley's avatar
julien-rivley
Icon for Helper I rankHelper 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...
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.

julien-rivley's avatar
julien-rivley
Icon for Helper I rankHelper 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

 

v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
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.