Forum Discussion
Matrix visualization with horizontal lines
Hello all.
I just started to use Power BI, read all the guided learning and still learning how to handle it. I need to insert in a matrix some informations and it must to show the description, value and percent value... all this information in the same line. I tried with both default matrix of Power BI but isn't what a need... or, I couldin't set up the fields correctly. Here's the exemple of what I have in mind:
And this is what I get:
So, if someone may help I'll be grateful!
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.
18 Replies
The lines are controlled under the paintbrush tab in the matrix's settings. There's a section there called Grid. Turn on "Horiz grid" and set the grid color to whatever you want.
As for the numeric results on your matrix I don't really know anything about the items you've placed in the Rows slot. If those are measures they should go under Values, not rows. Rows are just for the context items. Like if you had a sales matrix you would put Salesperson under rows and Total Sales under values.
Just to add to Anonymous's answer
Please Vote Here...
AND also here...
EDIT: This 2nd Idea is for Measures on Rows! (which as Anonymous said you may need to achieve your desired result!)
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.
