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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
GeekAlfPro
Resolver II
Resolver II

conditionnal format matrix

Hi,

 

I've got a matrix that display a measure that is the first day in the month where i've data in my dataset

GeekAlfPro_0-1678125655305.png

i'd like to format the cells when the value is empty or greater than 4 in red.

for that i try to select the measure in the conditionnal formatting but PBI doesn't allow it.

GeekAlfPro_1-1678125764801.png

When i click on the measure, the field remains empty

GeekAlfPro_2-1678125843756.png

it is possible to select a measure ?

do i have to set the styles in rules or field values ?

 

Thanks !

1 ACCEPTED SOLUTION
Padycosmos
Solution Sage
Solution Sage

Hope this helps: Also this video, not entirely related might give an idea: https://www.youtube.com/watch?v=7veYU1EeO6w

Padycosmos_0-1678127362230.png

 

View solution in original post

4 REPLIES 4
GeekAlfPro
Resolver II
Resolver II

Thanks @Padycosmos 

i finally managed with your first video.

it was my measure that had blank values.

 

Padycosmos
Solution Sage
Solution Sage

Padycosmos
Solution Sage
Solution Sage

Hope this helps: Also this video, not entirely related might give an idea: https://www.youtube.com/watch?v=7veYU1EeO6w

Padycosmos_0-1678127362230.png

 

Hello @Padycosmos 

 

Thanks for your suggestion.

unfortunately, it doesn't work for me.

my measure is considered as string

i tried to convert it to integer but without success so far

perhaps because i have null values

 

i'm still trying

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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