Format numbers in MATRIX

Hi Anonymous ,

Please refer to my .pbix file.

1. “I need only totals as totals of Actuals”

For this requirement, you can create a measure like this.

Measure = 
VAR x = 
SWITCH(
    SELECTEDVALUE(Sales[CountryRegion]),
    "dd", FORMAT( SUM(Sales[Sale 2014]), "Percent" ),
    FORMAT( SUM(Sales[Sale 2014]), "#, 0.00")
)
VAR y = 
CALCULATE(
    SUM(Sales[Sale 2014]),
    FILTER( ALL(Sales), Sales[CountryRegion] = MAX(Sales[CountryRegion]) && Sales[Month] = "December")
)
RETURN
IF(
    HASONEFILTER(Sales[Month]),
    x,y
)

2. Show the border of "Variance"

This requirement is currently not possible, but you can mark ‘Variance’ in other ways.

Firsr, create a measure like this.

Conditional format = 
IF(
    MAX(Sales[Month]) = "January",
    "Green"
) 

 Second, add the measure to the 'conditional formatting' label.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.