Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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! |
|
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |