Forum Discussion

Manas's avatar
Manas
New Member
4 years ago
Solved

How to give conditional Formatting to Matrix with data bars or background colors for time trend?

How to give conditional Formatting to Matrix with data bars or background colours for time trends? For eg., the following image shows Bike sales for 4 years. Need to have colour data bars /backgroun...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Manas ,

    Is this how you want it?
    You can use the measure given for the conditional formatting of cell color. 

     

    Cell Color = 
var a = SUM('Table'[Value])
var b = CALCULATE(SUM('Table'[Value]),SAMEPERIODLASTYEAR('Calendar'[Date]))
return
   IF(
       a>b,"#b3ffd9",IF(ISBLANK(a) || ISBLANK(b),"#ffffff","#ffb3b3")
   )

     

    Go to conditional formatting of value, select background colour, then select Field Value and select this measure.

    Attached .pbix for reference.
    Manas.pbix

    Regards,
    Aditya

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Manas ,

Is this how you want it?
You can use the measure given for the conditional formatting of cell color. 

 

Cell Color = 
var a = SUM('Table'[Value])
var b = CALCULATE(SUM('Table'[Value]),SAMEPERIODLASTYEAR('Calendar'[Date]))
return
   IF(
       a>b,"#b3ffd9",IF(ISBLANK(a) || ISBLANK(b),"#ffffff","#ffb3b3")
   )

 

Go to conditional formatting of value, select background colour, then select Field Value and select this measure.

Attached .pbix for reference.
Manas.pbix

Regards,
Aditya