Hidden filter and sort matrix/table with one date per table/matrix

[Anonymous]

Hi,

Does anyone know, if it's possible to have a hidden filter on a table/matrix? I have a table, where a priority coulmn is needed for a filter with lowest value on top - but this priority column should not be visible. Is this possible?

Furthermore, I need each table/matrix to be sorted by date. I have a column(int) with date attached to each order.

If possible it should look like this: If there are 3-4 different dates, they should also be visible in their own table/matrix.

Dispatch date: 10.05.2019
Store	Pick lines	Queue1	Queue2	Queue3
1 2 …	1 (50) 1 (37)	0 (0) 0 (0)	1 (50) 1 (37)	0 (0) 0 (0)

Dispatch date: 13.05.2019
Store	Pick lines	Queue1	Queue2	Queue3
1 2 6	9 (282) 12 (344) 10 (272)	5 (76) 9 (116) 8 (82)	0 (0) 0 (0) 0 (0)	3 (205) 3 (228) 2 (190)

Thanks in advance

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, feel free to ask.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I think we always use the visual level as an invisible filter for a visual.

So for your scenario, you may create a measure with Top N or RANKX function, and drag it in visual lever filter.

For your another requirement about date, I still have a little confused.

If it is convenient, could you explain it with your desired output so that we could understand better?

Best Regards,

Cherry