topic Sales Orders Name by Month in DAX Commands and Tips

Sales Orders Name by Month

P-Lag — Wed, 15 Feb 2023 08:47:12 GMT

Hi,

I need help creating a visual that looks similar to this. May it be solved with Dax?

A visual showing the invoiced orders for a specific month. I'm not interested to see any values of the sales orders. I have a date table and the order numbers. I believe it should be simple, but I have not suceeded after trying and googling for hours.

This is the closest I have to get a solution, but I want to see the sales order numbers in the "boxes", not as legends outside the graph. It's also quite messy 🙂

Thanks in advance!

Re: Sales Orders Name by Month

tamerj1 — Wed, 15 Feb 2023 10:23:37 GMT

Hi P-Lag

the simplest solution would be

CONCATENATEX ( VALUES ( Sales[Order Number] ), Sales[Order Number], UNICHAR ( 10 ), Sales[Order Number], ASC )

Re: Sales Orders Name by Month

P-Lag — Wed, 15 Feb 2023 11:20:17 GMT

Hi

It worked! This help made my day - A big thank you!

Now I have two following questions 🙂 Is it also possible to invert the range like this?

And also, is it possible to create a visual like this - that is more graphic 🙂

Thank you in advance 🙂

Re: Sales Orders Name by Month

tamerj1 — Wed, 15 Feb 2023 13:05:23 GMT

P-Lag
Try to to use "Tab" as a delimiter

= CONCATENATEX ( VALUES ( Sales[Order Number] ), Sales[Order Number], " ", Sales[Order Number], ASC )

Such visual would be much more complex. Try to avoid going into such complexity unless greatly needed.