Forum Discussion

h2bi's avatar
h2bi
Frequent Visitor
2 years ago
Solved

Color a specific matrix cell value

Hello In a Matrix with years in the column headers and Months in row headers How can i specify the font color of a specific vaue inside the matrix, like the value of the last month of my last year ...
Need Help
Tips and Tricks
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    h2bi 

    measure : 

    if it is the last year, then your last month is december im assuming the logic.

    you can write the fillowing measure : 

     

    colormeasure = 

    if  ( tbl_name[ monthnb] = 12 &&  tbl_name[year] = year(today()) - 1 ) , "Blue" ) 

     

    then add this measure to the condtional formatting  : right click  on the measure 

     

     

    select field value,  then search for your measure .

     

     

     

    let me know if this helps . 

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

     

     

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

h2bi 

measure : 

if it is the last year, then your last month is december im assuming the logic.

you can write the fillowing measure : 

 

colormeasure = 

if  ( tbl_name[ monthnb] = 12 &&  tbl_name[year] = year(today()) - 1 ) , "Blue" ) 

 

then add this measure to the condtional formatting  : right click  on the measure 

 

 

select field value,  then search for your measure .

 

 

 

let me know if this helps . 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠