Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
General Comment
Show and Tell
Tips and Tricks
Tutorial Requests
  • RMDNA's avatar
    RMDNA
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

RMDNA's avatar
RMDNA
Solution Sage
3 years ago

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