Matrix visual order

[learner03]

I have a matrix visual and when I put the values, it  comes up as (rows and column headers)-

But I need it to show the arrangement as this-

[Ashish_Mathur]

Hi,

You will have to use Sort by column feature in the Data Model.  There should be ample videos of this on YouTube.

[learner03]

@Ashish_Mathur But it is sort by column and row both in this condition.

[Ashish_Mathur]

Share the download link of the PBI file.

[learner03]

@Ashish_Mathur 
https://docs.google.com/spreadsheets/d/1K2Mm9XYkoOBRpXi-pQs5AxbY1aQMTqLg/edit?usp=sharing&ouid=11115... 

[Ashish_Mathur]

Try this approach.  DIY.

1. Create a 2 column table with People count bucket in the first column and numbers starting from 1 indicating the order of the particular bucket.  Sort the first column by the second column
2. Create a 2 column table with Time bucket in the first column and numbers starting from 1 indicating the order of the particular bucket.  Sort the first column by the second column.
3. Create a relationship (many to One and Single) from your Table to the tables created in 1 and 2 above
4. To your visual, drag People count bucket and Time bucket from the new tables ceated in 1 and 2 above
5.