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 One workaround is to put the Measures in a Multi-Row Card and adjust the size so only 1 Measure fit per line
Sean except he wants two measures per line, so that still won't look the way he wants it to look. I suspect the very specific appearance he's after is not possible.
Yep - that's why I posted the 2 Ideas (actually the 1st one is mine)
The Matrix needs MANY improvements (subtotals is another thing we can't control)
Sean is this matrix on PowerBi Desktop or Excel Power View? I am using Power BI Desktop.
By the way, this is the image of my powerbi to you figure out. (I made tags translating the names of columns cause my Power Bi is in Portuguese).
I thought about make a visualization, but I don't have experience and knowledge to, neither know if it is possible!
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.
