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

Question

Hi,&nbsp;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?&nbsp;Furthermore, I need each table/matrix to be sorted by date. I have a column(int) with date attached to each order.&nbsp;If possible it should look like this: If there are 3-4 different dates, they should also be visible in their own table/matrix.&nbsp;Dispatch date: 10.05.2019StorePick lines&nbsp;Queue1Queue2Queue312…1 (50)1 (37)0 (0)0 (0)1 (50)1 (37)0 (0)0 (0)&nbsp;Dispatch date: 13.05.2019StorePick linesQueue1Queue2Queue31269 (282)12 (344)10 (272)5 (76)9 (116)8 (82)0 (0)0 (0)0 (0)3 (205)3 (228)2 (190)&nbsp;Thanks in advance&nbsp;

v-piga-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
Based on your description, I think we always use the visual level as an&nbsp;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
&nbsp;

Forum Discussion

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

2 Replies

Related content

Matrix table

Matrix table

KPI level matrix table

Matrix table in Power bi

PowerBI - Matrix table, hide values used only for a visual calculation

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)