Forum Discussion
Matrix visualization with horizontal lines
wesleyvieira if they are columns, you'll get a row for each value in each column, and the $ and % will calculate on each row. The closest you'll get is probably a card as Sean suggested. It won't be formatted the way you want it but it will give you the values you want. The formatting you want is...just not how any of the visuals work.
wesleyvieira I'm not sure what you want to do with these 4 Columns?
Do you want to show only the OVERALL Totals for these 4 columns you currently get on the bottom of the Table?
So only the Totals but vertically instead of horizontally?
Sean, I want to show them horizontally with total in the same row and the percent they represent (by mesaure). Just like below:
Cost of service $ 14,345 100.00%
Mkt Actions $ 2,892 20.16%
Equipments $ 5,027 35.04%
Containers $ 6,426 44.80%
It´s columns that I need to show in rows.
But I will give up... seems do not be possible to do this way.
Do you have SUM Measures for these 4 columns?
Create 4 Measures for each column!
Measure Name = SUM ( TableName[ColumnName] )
Then put these 4 Measures in a Multi-Row Card Visualizaiton (yes thats in PBI)
When it´s in columns in the table, they sum automatically.
Sean, comes from my database.
Cost of service, MKT Actions, Equipments, Containers... are the name of my columns in database, and the values are the sum of those columns.