Matrix Formatting

[Anonymous]

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"
                )
)

[harshnathani]

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/

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/conditional-formatting-totals-subtotals

Regards,

Harsh Nathani

[Anonymous]

thank you for your reply, but it doesn't help. Does anyone have any other suggestions?

[Anonymous]

Seriously, no option to remove the subtotals from the rows or to color whole column without white spaces... ?

[harshnathani]

Hi @Anonymous ,

See if this video helps you.

Some cool tricks for matrix visualization

https://www.youtube.com/watch?v=58a2rIV2nYg

Regards,

Harsh Nathani

[DataInsights]

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