Icon conditional formatting

Sri_phani — Fri, 28 Jun 2024 11:25:20 GMT

Hi,

I am trying to apply icon conditional formatting to the matrix comparing current month scores with previous month. I have created the measure and it's working fine.

Recontact Difference =

VAR score = CALCULATE(

[Recontact],

DATEADD('Calendar'[Dates],-1,MONTH)

)

VAR Diff = [Recontact]-score

RETURN

Diff

But the problem is with the starting month January 2024. For that values the conditional formatting should show blank. But I am getting arrows. My data start from January 2024.

For information, my data model has Recontact column for which measure created - Average('raw data' [Recontact] and Many to One relationship between Raw data table and calendar table.

Appreaciate any help in this.

Thank you!

Re: Icon conditional formatting

lbendlin — Sun, 30 Jun 2024 14:39:11 GMT

Recontact Difference =

VAR score = CALCULATE(

[Recontact],

DATEADD('Calendar'[Dates],-1,MONTH)

)

VAR Diff = [Recontact]-score

RETURN IF(NOT ISBLANK(score),

Diff)

Re: Icon conditional formatting

Sri_phani — Sun, 30 Jun 2024 17:39:33 GMT

Thank you lbendlin, it worked like a magic

topic Re: Icon conditional formatting in DAX Commands and Tips

Icon conditional formatting

Re: Icon conditional formatting

Re: Icon conditional formatting