Matrix visual order

Question

I have a matrix visual and when I put the values, it&nbsp; comes up as (rows and column headers)-But I need it to show the arrangement as this-&nbsp;&nbsp;&nbsp;

ashish_mathur · Answer

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

learner03 · Answer

Ashish_Mathur&nbsp;But it is sort by column and row both in this condition.

ashish_mathur · Answer

Share the download link of the PBI file.

learner03 · Answer

Ashish_Mathur&nbsp;https://docs.google.com/spreadsheets/d/1K2Mm9XYkoOBRpXi-pQs5AxbY1aQMTqLg/edit?usp=sharing&amp;ouid=111156603195529711452&amp;rtpof=true&amp;sd=true&nbsp;

ashish_mathur · Answer

Try this approach.&nbsp; DIY.

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.&nbsp; Sort the first column by the second column
Create a 2 column table with Time bucket in the first column and numbers starting from 1 indicating the order of the particular bucket.&nbsp; Sort the first column by the second column.
Create a relationship (many to One and Single) from your Table to the tables created in 1 and 2 above
To your visual, drag People count bucket and Time bucket from the new tables ceated in 1 and 2 above
&nbsp;

Forum Discussion

Matrix visual order

5 Replies

Related content

Matrix component - order question

matrix rows order

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual