Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 highlighted in blue color
Solved! Go to Solution.
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! 🤠
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! 🤠
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 49 | |
| 41 | |
| 41 | |
| 22 |
| User | Count |
|---|---|
| 171 | |
| 136 | |
| 119 | |
| 80 | |
| 54 |