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.
Hi Anonymous.
Yeap... I really think we were editing our messages at the same time! lol
The fact is that I am still trying to get the visualization and no success! This time, I tried to use "table", but it still shows all information in columns instead of rows. The information I get with the table of PowerBI is:
Cost of service Mkt Actions Equipments Conteiners
$ 14,345 $ 2,892 $ 5,027 $ 6,426
100% 20.16% 35.04% 44.80%
And I must to be shown:
Cost of service $ 14,345 100.00%
Mkt Actions $ 2,892 20.16%
Equipments $ 5,027 35.04%
Containers $ 6,426 44.80%
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)
Anonymous Cost of service, Mkt Actions, etc.. are columns, "$" the rows and "%" are measures.
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.
