Forum Discussion
Adding a column with specific values
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!
Hi Anonymous,
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
3 Replies
- Hi Anonymous,
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,
MFelixHi 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?
Hi Anonymous,
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