Sorting by values in matrix

[diksha05]

Hi i am trying to sort dates in a matrix visual using dates as a values, company names(competitior companies - A, B, C etc.) in columns and cities in rows....But i am not able to sort by dates in ascending order.

The desired output is sorting dates in ascdening order with cities irrespective to company names & company order. PFB

I am using matrix visual in Power BI to display this. Could you help me to solve this ?

Thanks in Advance! 

[amitchandak]

@diksha05 , I doubt this is possible. Instead of that make Date as column(Pivot) and display company as a measure.