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.

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.

      • aws1967's avatar
        aws1967
        Regular Visitor
        9 years ago

        Excuse me, but I don't understand. "Averange of ..."  is add automatic when use aggregate function. I change name of column through "Rename" in interface "Fields" and name is changed. But "Averange of ..." in front of new name is remain.

         

        Best regards? Aleksandr.