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
Ohboy_991
Frequent Visitor

Red & green Icon (traffic ) using Conditional formatting

Hello All,

 

I need help with a Conditional Formatting.

 

I have a measure in a Matrix named as Factor. It is derived using this DAX

 Factor = ([Commited Amount] / (SUM(Tab1[OP])-SUM(Tab2[Sales Amount])))
 
I also have a slicer created using a parameter,  the slicer has values -- 2, 3 and 4
so whenever i select any value in the slicer, let say i choose 3 it should subtract the factor value and if the value is greater than or equal to the chosen value ( in this case 3 ) a green button 🟢 should come left of the data or else 🔴
Example 
Ohboy_991_1-1705064937298.png

 

Thank you for the help.

 

 
 
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Ohboy_991   
Since you did not attach sample data for the index you calculated, I prepared a simple data set like in the picture and will demonstrate a  solution with a simple sum formula.
The table :

Ritaf1983_4-1705207211546.png

 

parameters fo slicer:

Ritaf1983_1-1705206743913.png

The measure (instead of yours):

factor_ = sum('Table'[Factor])
The measure for the conditional formatting of circles :
flag_traffic = IF([factor_]>=Selections[Selections Value],"g","r")
The modifying of conditional formatting :
 
Ritaf1983_2-1705206907598.png

 

 

The result :

Ritaf1983_5-1705207250538.png

 

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @Ohboy_991   
Since you did not attach sample data for the index you calculated, I prepared a simple data set like in the picture and will demonstrate a  solution with a simple sum formula.
The table :

Ritaf1983_4-1705207211546.png

 

parameters fo slicer:

Ritaf1983_1-1705206743913.png

The measure (instead of yours):

factor_ = sum('Table'[Factor])
The measure for the conditional formatting of circles :
flag_traffic = IF([factor_]>=Selections[Selections Value],"g","r")
The modifying of conditional formatting :
 
Ritaf1983_2-1705206907598.png

 

 

The result :

Ritaf1983_5-1705207250538.png

 

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.