Forum Discussion
maximum value in a matrix visual
Dear Community,
Please I need help. I need to make a matrix visual that shows the maximum value of the fixed hours column but shows the sum of the other columns. See image illustrating my problem.
HI Anonymous - you don't have to create new columns yourself or change your original data source, you can pivot the attribute column in PowerQuery. If you want to avoid changing that table at all, I'm not sure that's possible, since you can't have different aggregation levels for a single value field
3 Replies
Hi Anonymous - in the Columns section of the visual properties, just change the aggregation type of the field to the one you want. Then you can rename the columns to whatever name you prefer. This works in both tables and matricies.
Thank you RMDNA for your quick answer. But my data is in this format below (FIG 1) in the data table.
FIG 1
While I want it to be in a matrix table visual like this below
FIG 2
However, from your answer, I had to change the query to present the data table in the format in Fig 2 by creating additional columns for Fixed, Planned and Registered Hrs which helped me solve the problem, but I would still love to leave my data table the way it is originally and have the matrix visual to not sum the fixed hours.
I would still appreciate any help on how to do that.
Thank you.
HI Anonymous - you don't have to create new columns yourself or change your original data source, you can pivot the attribute column in PowerQuery. If you want to avoid changing that table at all, I'm not sure that's possible, since you can't have different aggregation levels for a single value field