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...
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
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

 

 

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

Hi julien-rivley ,

 

Sorry for that there is no way to allow non numerical data on the Y Axis.

But you can refer this solution,

 

1. Copy an original table and get a dim table that contains Product in Power Query. Use the GROUPBY function.

 

 

2. Then remove the Count column and add an index column.

 

 

3. And we need to create a relationship between the new table and old table.

 

 

4. At last we can create a scatter table like this, and add two slicers to control the product.

 

 

 

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

BTW, pbix as attached.

 

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

    Hi,

     

    Thanks a lot for the proposed solution.

    I tried to do it and I end up with that kind of graph:

     

    I have more than 500 products and my data are purchase orders. I would like to display the chart for one purchase order and one purchase contains multiple products that don’t necessarily have products with similar index. (and multiple deliveries for each product)

    I guess a "dynamic index" calculated with a measure would help?

     

    Thanks,

    Julien