Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Matrix visual - Conditional formatting icon is not visible when applying some filters in power bi

Hi PowerBians ,   I am using Target based Matrix table for many KPIs , targets already defined and based on the target we are calculating the values on monthly basis . Here the problem is the icon ...
General Comment
Need Help
Tutorial Requests
DataVitalizer's avatar
DataVitalizer
Super User
2 years ago

Hi Anonymous 

Could you share the formula of the Rag_Status column? It might be a code issue.


Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    DataVitalizer 

    Rag_Status = IFERROR(IF(AND(ISBLANK(CBS_SLA_DATA[Numerator Value]),ISBLANK(CBS_SLA_DATA[Denominator Value])),BLANK(),IF(CBS_SLA_DATA[NewTarget Type]="TBD",0,IF(CBS_SLA_DATA[SLA_Value_Type]="P",(IF(ISBLANK(CBS_SLA_DATA[Numerator Value]),BLANK(),IF(ISBLANK(CBS_SLA_DATA[Denominator Value]),BLANK(),IF(CBS_SLA_DATA[NewTarget Type]="HTB",IF(CBS_SLA_DATA[Numerator Value]/CBS_SLA_DATA[Denominator Value]>=CBS_SLA_DATA[New Target],1,-1),IF(CBS_SLA_DATA[NewTarget Type]="LTB",IF(CBS_SLA_DATA[Numerator Value]/CBS_SLA_DATA[Denominator Value]<=CBS_SLA_DATA[New Target],1,-1)))))),(IF(ISBLANK(CBS_SLA_DATA[Denominator Value]),IF(CBS_SLA_DATA[Numerator Value]<=CBS_SLA_DATA[New Target],1,-1),IF(CBS_SLA_DATA[Numerator Value]/CBS_SLA_DATA[Denominator Value]<=CBS_SLA_DATA[New Target],1,-1)))))),BLANK())