Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Masters,
I want to colour W38 to show which week we are like below.
Is it possible? any advice would be much appreciated.
thank you,
CL
Solved! Go to Solution.
@colourfullife Oh, wait, syntax error, missing )
Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
@colourfullife I don't see where you can set the color of a line based on a formula yet. So like:
Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())
X axis in the graph, there are Weeks,
2020-21, 2020-22, 2020-23, 2020-24 . . . . .
i want to colour 2020-38.
@colourfullife Right, still no conditional formatting for that. You could add a new line that only displays on the current week, so that it shows as a dot and set it to a value of 1 perhaps. Then that would indicate current week.
@Greg_Deckler, That's a good idea!
can you let me know what i should do if i'd like to have the line?
thanks,
CL
@colourfullife Thinking:
Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())
@colourfullife Hah!, didn't think about that! OK, that's easy to fix:
Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY() && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
Hi @Greg_Deckler thanks for your reply.
I honestly have no idea of this dax..
this time, it didn't appear?
@colourfullife Oh, wait, syntax error, missing )
Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
@Greg_Deckler oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂
@colourfullife Sorry we couldn't get there completely in the end, but if this at least gets you something, mark it as an answer so others can benefit! 🙂
@colourfullife Hmm, so Calendar[Date] is used in you x-axis?
@colourfullife I think it was a syntax error on my part, corrected below.
Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
@colourfullife Unfortunately no, haven't found a way to draw vertical lines on line charts yet. The Analytics pane only allows horizontal lines. Unless...you want to create a bunch of those measures, each with a different value that is returned, so think 10 of those measures that return values from 1 to 10 each, then they would show up stacked vertically on the graph. Maybe create one for every 2000? 😞
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |