Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dinesharivalaga
Helper IV
Helper IV

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 is not visible when applying some filters in filter panel (Working in Single selection , Not working in Multi selection) .

 

Multiple selection of countries - Not working , few icons missed and few is wrong (even target is matched)

dinesharivalaga_0-1700553348238.png

Single selection of country (In slicer or filter panel) - Its working 

dinesharivalaga_1-1700553565461.png

I don't know what kind of behaviour is this from Conditional formatting feature .

Below the Conditional formatting setup :

dinesharivalaga_2-1700553668895.png

 

Please help to solve this ..

Thanks in advance ..

 

 

 

2 REPLIES 2
DataVitalizer
Super User
Super User

Hi @dinesharivalaga 

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

@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())

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.