Forum Discussion

aws1967's avatar
aws1967
Regular Visitor
9 years ago
Solved

Formatting matrix preview

Hi. I use Power BI Desktop Free and have matrix (in picture NOW). I need to format it look like picture "I need approximately". In addition, i need to format numeric values in columns to "Numeric wi...
Need Help
  • aws1967's avatar
    aws1967
    9 years ago

    OK. Thank you very much.

dilumd's avatar
dilumd
Impactful Individual
9 years ago

I don't know whether i understood your question correctly but this is my solution for your concern. Select your table and go to below and change it according to your preference.

 

 

To get numeric with 000' separator click on Modeling tab and click on below "," mark and get number of decimal places you want.

aws1967's avatar
aws1967
Regular Visitor
9 years ago

Thank you very much for quick ansver. About formatting numeric values - your ansver is very useful! I didn't know this. About borders around groups in table -  this style almost fit for me, but I want border lines such as red line on picture after every group "Нед1","Нед2" ect. Is it possible to manage this? If so, how?

 

Best regards, Aleksandr.

 

 

  • dilumd's avatar
    dilumd
    Impactful Individual
    9 years ago

    No! to my knowledge with the current version of Power BI that is not possible but just go through the table formats there can be some alternative for you.

    • aws1967's avatar
      aws1967
      Regular Visitor
      9 years ago

      Hi.
      OK. I understood. Annoyingly. I will try to use colours...
      I have the next question: how to change Name of column, when this name setted automatic? Example in the picture. Instead "Averange of ДнНал" I want write anything else, without "Averange of...". In pivot table it is no problem...

      Best regards, Aleksandr. 

       

       

       

      • dilumd's avatar
        dilumd
        Impactful Individual
        9 years ago

        Change the name of the column on your table layout and it'll automatically change in the created table.