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 with separators". Block "Format" for this visualization do not allow do it (or I don't know how...).
Tell me, please, how to make this formatting.

Now 

 

I need (approximately)

 

 Best regards, Aleksandr.

 

8 Replies

  • dilumd's avatar
    dilumd
    Impactful Individual

    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

      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

        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.