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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Rpaiva8
New Contributor

Conditional formatting based on filter selection

hello,

 

I am trying to find a way that I can base my conditional formatting on a filter selection.

The idea is to grade results using ICONS from conditions formatting, but the issue I have is that I have different parameters for different regions. 

 

I have a reference table that shows for REGION 1 the following parameter:

grade to 5.JPG

Then once a select REGION 2 on the filter, below is the new parameter:

grated to 2.JPG

 

 

 

 

The total results are displayed on a single RESULTS table like so:

results.JPG

 

Is there a way that, depending on the REGION filtered, different conditional formatting parameters are applied?

thanks.

1 REPLY 1
lbendlin
Esteemed Contributor III

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Users online (3,586)