Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

POWER BI Matrix Values alignment in Centre

Hi All,

   I was trying to Center the Values in the Matrix.

  

 

I want the Data Value "1" in the Center

 

In WORD - this can be easily done through - Layout - Center

 

 

Can you please help, if we have similar functionality in POWER BI.

 

I am attaching the POWER BI PBIX File for your Ref.

 

Regards,
Venkat

 

 

Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    5 years ago

    Hi Anonymous ,

    If I understand you correctly, go to the format, paintbrush, and see as in picture below.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

10 Replies

  • berto2002's avatar
    berto2002
    New Member
    2 years ago

    This is not a coplete solution.

    When I click the "Alignment" of "Center" in "Values", only ONE column of the matrix centres (the first of the matrix columns), the others remain aligned left.

    Is this is bug in PowerBI?

     

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    5 years ago

    Hi Anonymous ,

    If I understand you correctly, go to the format, paintbrush, and see as in picture below.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Same question as OP, judging from the screenshot this is an old version and there is no longer field formatting under paint brush

     

    I have a bigger font for row headers than the values, and now all the values are hovering at the top of the cell

    • cloth's avatar
      cloth
      Frequent Visitor
      4 years ago

      Vertical centering isn't supported from what I can tell. 

       

      I was able to find horizontal centering buring in the new Format Visual menu.  It is still under the "Format your visual" tab, but they've really buried it now.  Expand "Specific Column", select the name of the series you wish to center, scroll down further to "Values" and the select the alignment you wish to use (left, center, or right).

       

       

      • Lorenski's avatar
        Lorenski
        Frequent Visitor
        3 years ago

        Ugh, why did they bury it so deeply???  Please tell me I'm missing something!

         

        I just built a rather complex matrix with columns and sub-columns.  I now have to click countless times to get them all individually centered!  This is so easy in Word or Excel.  There should at least be an option to apply this to all columns.

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    5 years ago

    Hi Anonymous ,
    Where is the file?

    Thank you,


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel