Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
7 months ago
Solved

Background color Set

hi team How  to set backgrount color for a.Revanue,Total A.Revennue ,B.Expense,Total B.Expense
Need Help
Tips and Tricks
Tutorial Requests
  • v-sshirivolu's avatar
    v-sshirivolu
    7 months ago

    Hi rajasekar_o ,

    You can achieve different background colors for specific rows in a Matrix by using a measure and applying it through conditional formatting.

    Create a background color measure - 

    Row Background Color =
    SWITCH (
    SELECTEDVALUE ( Financials[Description] ),
    "A.Revenue", "#E3F2FD",
    "Total A.Revenue", "#90CAF9",
    "B.Expense", "#FCE4EC",
    "Total B.Expense", "#F48FB1",
    "#FFFFFF"
    )

     

    Please find the below attached .pbix file for your reference.

     

Irwan's avatar
Irwan
Super User
7 months ago

hello rajasekar_o 

 

please check if this accomodate your need.

1. create a new measure with following DAX.

Color Palette =
IF(
    SELECTEDVALUE('Table'[Description])="A",
    "Red",
IF(
    SELECTEDVALUE('Table'[Description])="C",
    "Blue"
))
2. select your table visual, then go to Cell Element then which conditional color you want, then go to Format Style, then pick the measure that has been created.

 

Hope this will help.

Thank you.