cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lardo5150
Microsoft
Microsoft

How to color code background of SINGLE cell based on another

I have data coming from dataverse

 

Engineer | Availability | TotalCases | Date

user1         Unavailable      0             1/1/2023

User2        Available           2              1/2/2023

 

I have built out a matrix like below.  How do I highlight a single cell if the text in Availability is "Unavailable"?

 

lardo5150_0-1673035518408.png

 

So using my example above, if the first engineer on the 6th, if their Availability for that day was Unavailble, we would highlight the backround of that cell.

2 REPLIES 2
lardo5150
Microsoft
Microsoft

Unfortunately no.

I am trying to color a cell, based on ANOTHER cell.  That other cell is not presented as a visual in the graph.

djurecicK2
Resident Rockstar
Resident Rockstar

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors