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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.