Forum Discussion

wesleyvieira's avatar
wesleyvieira
Helper I
10 years ago
Solved

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, va...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

  • wesleyvieira's avatar
    wesleyvieira
    Helper I
    10 years ago

    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:

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      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.

      • wesleyvieira's avatar
        wesleyvieira
        Helper I
        10 years ago

        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%