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 don't know what Cost of service, Mkt Actions, Equipments and Containers are. Are they each different measures? If so that will never work. Are they values from a column in your dataset? If so you can put that column in the Rows slot, then add your sum and % measures to the values slot.
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!
