Forum Discussion

Luis_Caston's avatar
Luis_Caston
Icon for Helper III rankHelper III
2 years ago

Dinamic color x-axis

Dear all,
I'd like to give red color to the x-axis to the todays weeknumber.
I've created this formula:

Color Numweek =

    var _uparrow = UNICHAR(129137)
    VAR _downarrow = UNICHAR(129139)
    var _variance =
        WEEKNUM(UTCNOW())

    var _numweek = MAX(Calendario[NUMWEEK])    
RETURN

    IF( _numweek = _variance,
         "Red", "Grey")
 
But is not working take a look:todays week is 31 but remains grey.
 

On the contrary at a matrix is working:

 

Do you know why is not working at the x-axis graph?

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    2 years ago

    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

  • Luis_Caston's avatar
    Luis_Caston
    Icon for Helper III rankHelper III
    2 years ago

    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?