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.
Hey Khorseman,
Thank you for your reply, but what I need is to put the column in lines... I´ve attached a new image of the same information I have in excel and PowerBI. Formatting is easy.. I already new about it.! :smileyvery-happy:
wesleyvieira I think we must have both been editing our posts at the same time. Check my answer again. I think you have measures in the wrong place. Everything is in the Rows slot on your matrix, with nothing under Values. Totals and percentages are calculated as values per row. The row slot is only for labels and categories and things like that.
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
