Forum Discussion
Formatting Matrix table
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.
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])/100
and 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