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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.