Formatting matrix preview

[aws1967]

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.

[dilumd]

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]

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]

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]

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]

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

[aws1967]

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.

[dilumd]

Unfortunately, you can’t change the column name if you use average feature under values section like below.

Instead, create a new measure using average function and put a name you prefer.

https://msdn.microsoft.com/en-us/library/ee634231.aspx

You can also vote for below idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18123031-change-column-labels-nam...

[aws1967 · Accepted solution]

OK. Thank you very much.