Forum Discussion
Matrix Formatting
Hello,
I have a few questions about formatting in the matrix.
1. How can I hide these totals for the category (row) marked in blue (Financials)? I don't want any numbers to appear in there.
2. How can I color all "cells" in columns vPY and vOP (marked in green)? For some reason, the color appears only for the values and this looks ugly with a white background on the category name level.
3. You can also notice, that the horizontal grid between, for example, Backlog Turns and Idle Backlog (or Idle Backlog % and On-hold Backlog) is lighter or thinner than the ones between Backlog & Backlog Turns or On-hold Backlog and On-hold Backlog %. Do you know how to make it equal thick?
Here is my measure for "Current" column:
Value-CY-Txt =
FORMAT(
calculate(sum('fact_Metrics'[Value]),'dim_Calendar'[Date].[Year]=2020,'fact_Metrics'[Scenario]="Actual"),
SWITCH (
TRUE (),
MAX(dim_Metrics[Data Type])="Ratio", "0.0%",
MAX(dim_Metrics[Data Type])="Currency","$#,0",
max(dim_Metrics[Data Type])="Number","0",
max(dim_Metrics[Data Type])="Decimal","0.0"
)
)
5 Replies
- DataInsightsSuper User
Hello,
You might try the custom visual Financial Reporting Matrix. It gives you more control over formatting, etc.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000642?tab=Overview
Wiki: https://github.com/Profitbase/PowerBI-visuals-FinancialReportingMatrix/wiki
- AnonymousNot applicable
Hi Anonymous ,
Have a look at the blog for matrix formatting
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://www.burningsuit.co.uk/blog/2020/03/power-bi-conditional-formatting/
Regards,
Harsh Nathani
- AnonymousNot applicable
thank you for your reply, but it doesn't help. Does anyone have any other suggestions?
- AnonymousNot applicable
Seriously, no option to remove the subtotals from the rows or to color whole column without white spaces... ?