Multi Dimension Visual with Dates

[julien-rivley]

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

[v-zhenbw-msft]

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]

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 · Accepted solution]

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]

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]

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]

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

[lbendlin]

Give your products a numerical index.

[julien-rivley]

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]

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