Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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