Forum Discussion
Formatting Matrix table
I have created a matrix table. with several rows, some of which have text "%" included in them. I need to format these specific rows in % format, rest I want in the integer format. Also the rows have to be sorted basis a helper column. is it possible.
Sr. No. | Criteria | Q1 | Q2 | Q3 | Q4 |
| 1 | Sales | 100 | 200 | 300 | 400 |
| 2 | GOP | 10 | 20 | 30 | 40 |
| 3 | GOP % Sales | 0.1 | 0.1 | 0.1 | 0.1 |
I am creating a matrix table where the row is "criteria". I need to sort it in the order of "Sr. no." column. Also rows having text "%" should be in format 0.0%
Hi jvazhach
Custom sort your Criteria column by Sr. No. -https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?wt.mc_id=MVP_447534
Use dynamic format strings for the formatting.
8 Replies
Hi jvazhach
The quick and dirty way to do it , I think you an create measure for each Quarters similar to this
Q1_M = SUM('YT'[Q1])/100and use it as values , to change the the measure to percentage click the measure -> and click % and 1 decimal places
and if you want to sort criteria based on Sr.no then you can click criteria column -> click sort by column and pick Sr.no
Hi KushanNA,
Thanks for your response. The table needs to have partial row values in number format and rest of row values in percent format. I guess the above measure uniformly converts all row values to percent format.
Also, I need to sort the table by Sr. No. without it being a part of the table. Will that still work. So basically I have a database with Profit and loss statements for multiple locations and I am trying to create a report which slices the data by different filters and gives the user the option to see the profit and loss statement for the selected filters
Hi jvazhach
Custom sort your Criteria column by Sr. No. -https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?wt.mc_id=MVP_447534
Use dynamic format strings for the formatting.
Hello danextian,
Thanks for your response. How can I enable the table tools and measure tools option in PBI desktop.
I dont see those
Hi jvazhach ,
Thank you danextian and kushanNa for the helpful answers!Thanks for your follow-up!
The Table tools and Measure tools tabs appear only when you select a measure or calculated column in the Fields pane. Try clicking on your measure ,the ribbon updates automatically. Dynamic format strings work only with measures, not columns.
Hope this helps.If so,consider accepting it as solution.
Regards,
Pallavi.
Hi jvazhach ,
Thank you danextian and kushanNa for the prompt response!
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by danextian and kushanNa . I hope it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.
Thank you.Hi jvazhach ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.Hi jvazhach ,
I wanted to check and see if you had a chance to review our previous response. Please let me know if everything is sorted or if you need any further assistance.
Thank you.
