Metric To retrieve a number and conditional formatting

Hi NewbieJono 

 

Is your [%] a measure or a column? If it is a measure, you can create a measure like below to get the value

 

% of 1-2 Days = CALCULATE([%], 'TableName'[day]="1-2 Days")

 

If [%] is a column, you can try a measure like below (assume that you select max for the value in the current matrix)

 

% of 1-2 Days = CALCULATE ( MAX ( 'TableName'[%] ), 'TableName'[day] = "1-2 Days" )

 

You can use conditional formating feature to highlight some values in a matrix. It seems there are three value fields (vol, cumulative, %) in the matrix now. As the conditional formatting is only available for values, not for row/column, you need to set the conditional formatting for every value field one by one. 

 

For example, you can create a measure for color. Use this measure for color formatting all value fields. However, the row header cannot be formatted like this. And it doesn't support to highlight a specific row header value currently.

 

color measure = IF(SELECTEDVALUE('Table'[day])="1-2 Days","#EFB5B9")

 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!