Adding a column with specific values

[Lorraine]

Hi!

I'm working on a report right now and there's a visual that I need some assistance with. I'll explain it the best I can, if it doesn't make sense let me know!

Currently I have this matrix:

I have variables set up on the left and their total cost to the right. To set up the matrix this way I chose to show values on rows instead of columns so there was a vertical table rather than a horizontal one. This setup so far is great. However, I want to have an additional column to the right of the total costs. I want to add a "max amount" column or something similar. For example, the second row has a total of $20,436.26. If the "max amount" for that variable was $45,000 I would want that displayed in a cell next to the total so far.

If this is possible, I'd love some guidance on how to set it up. Thanks in advance!

[MFelix]

Hi @Lorraine,

Just add the columns on the.matrix and choose the max value so you will.have two columns one with the total another with.max but.both are deriving from.the same.column.


You can add a column the numbers of times you need to a matrix.visual and it will.grow.

You can also make.calculated measures for each of your matrix.column and add them side by side.

Regards,
MFelix

[Lorraine]

Hi @MFelix,

I found the area where I can add a column. However these max amount values I would like to add aren't entered in my powerbi file yet. Do you know how I can add them and then have them them added as a column? 

[MFelix · Accepted solution]

Hi @Lorraine,

You must change the aggregator on the columns so you get the result, another way would be to make a measure, no need to add a new column or table with max values:

Regards,

MFelix