Forum Discussion
Multicolumn filtering on Table Visual
Are your dates stored as actual date formats as the table will usual still sort these correctly if they are dates and not text as shown in your example
unfortunatly the table visual only allows sorting by one colunm
one method to sort is if you are already sorting them in the advanced query editor then apply colunm for row number during this stage you will then be given a new colunm going in the correct order and you can include this in your table and sort on this new colunm to achive your results.
another method is to create a calculated colunm for the customer + the date with the date in a standard format
for example
Column = 'Table'[CustomerName ] & " " & FORMAT('Table'[OrderDate],"yyyy-mm-dd")this will create a unique colunm that will always sort by customer and then date (when date is in year-month-date format it will sort in the correct order as text)
Are your dates stored as actual date formats as the table will usual still sort these correctly if they are dates and not text as shown in your example
unfortunatly the table visual only allows sorting by one colunm
one method to sort is if you are already sorting them in the advanced query editor then apply colunm for row number during this stage you will then be given a new colunm going in the correct order and you can include this in your table and sort on this new colunm to achive your results.
another method is to create a calculated colunm for the customer + the date with the date in a standard format
for example
Column = 'Table'[CustomerName ] & " " & FORMAT('Table'[OrderDate],"yyyy-mm-dd")this will create a unique colunm that will always sort by customer and then date (when date is in year-month-date format it will sort in the correct order as text)
Thanks a lot for your input. Yes dates are being stored in actual format and PowerBI is loading them correctly as dates.We will try to follow one of the two alternatives you suggested.
