Matrix's backgroud color

2024-06-21T16:06:29.46+00:00

HI, I NEED A HELP

I HAVE A MATRIX, AND I WOULD LIKE TO CHANGE THE BACKGROUND COLOR WHEN THE AGREGATED VALUE IS UNDER THAN 92K.

I TRYED TO USER A SIMPLE SWITCH OR IIF (IN TABLIX ITS WORKS FINE), BUT IT CHANGE ALL CELLS IN THE MATRIX...

 

HOW CAN I DO THIS FOR EACH COLUMN YEAR?

 

THANKSScreenshot 2024-06-21 at 10.39.46.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,873 questions
{count} votes

Accepted answer
  1. ZoeHui-MSFT 35,546 Reputation points
    2024-06-25T01:30:03.9666667+00:00

    Hi @Luciana Iura de Oliveira Mello de Melo,

    I used below code in the sales column and it works fine, please have a check.

    =iif(Fields!sales.Value>9300000,"red","No color")

    User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. 2024-06-24T11:43:20.84+00:00

    Hi @ZoeHui-MSFT , sorry if I wasn't clear. I would like to highlight in a Matrix, the values ​​that are above 92,000.00. Attached is the result I need. I need to highlight this value per year, as shown in the image. Thanks for listening.

    0 comments No comments