Forum Discussion
Group by visual?
Hi,
I've got at visual table looking like:
Supplier Date ProcureNO Product
1 1.10.20 1 a
2 10.10.20 2 b
3 15.10.20 3 c
3 15.10.20 3 d
3 15.10.20 4 e
3 15.10.20 4 f
4 22.10.20 5 g
Can i somehow group the data by date and supplier so that it shows in the following way:
Supplier Date ProcureNO Product
1 1.10.20 1 a
2 10.10.20 2 b
3 15.10.20 3 c
3 d
4 e
4 f
4 22.10.20 5 g
I hope that you can help 🙂
@HypnoHans , Visual Matrix , Stepped Design ?
reference:https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
4 Replies
@HypnoHans , Visual Matrix , Stepped Design ?
reference:https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Perfect, thank you!
Can I sort by date even tough it is the second column in the table?
Right now, when supplier is the first colum it sorts like:
Supplier Date
1 10.12.20
1 15.12.20
2 3.11.20
2 14.11.20
I want it to be like:
Supplier Date
2 3.11.20
2 14.11.20
1 10.12.20
1 15.12.20
it that possible? 🙂
Anonymous , You have option to sort on three dots, check that out. You should be able sort Supplier Descending
Yes, thank you.
But it is actually not descendig suppliers that i need.
The suppliers can come like:
Suppliers
1
4
2
6
1
It is the date that should "decide" which supplier to show first.