Forum Discussion
learner03
Post Partisan
Post PartisanMatrix visual order
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
Super User
Super UserHi,
You will have to use Sort by column feature in the Data Model. There should be ample videos of this on YouTube.
learner03Post Partisan
Post PartisanAshish_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
Try this approach. 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. 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. 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