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
Dear all,
I'd like to give red color to the x-axis to the todays weeknumber.
I've created this formula:
On the contrary at a matrix is working:
Do you know why is not working at the x-axis graph?
Hi!
Thank you for your support!
I've add it here:
I've changed the color to blue (when conditions not) to see if something happens but "Red" condition is no working.
Do you guess why?
@Luis_Caston You can try below mentioned way
First create a measure for Current weeknum
CurrentWeekNumber = WEEKNUM(TODAY())
Create a measure for Color
WeekColor =
VAR _currentWeek = [CurrentWeekNumber]
VAR _numweek = MAX(Calendario[NUMWEEK])
RETURN IF(_numweek = _currentWeek, "Red", "Grey")
Select the visualization where you want to apply the conditional formatting.
Go to the Format pane.
Expand the Data colors section.
Click on the fx button next to the color you want to change.
In the Default color dialog, select Field value.
Choose the measure [WeekColor] you created.
This approach will not change the color of the x-axis labels directly but will change the color of the data points based on the week number
Proud to be a Super User! |
|
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |