Sales Orders Name by Month

[P-Lag]

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! 

[tamerj1]

Hi @P-Lag 

the simplest solution would be

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

[P-Lag]

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 🙂 

[tamerj1 · Accepted solution]

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