cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Partisan

## Colouring this week x axis in graph

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

1 ACCEPTED SOLUTION
Super User

@colourfullife Oh, wait, syntax error, missing )

``````Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
16 REPLIES 16
Super User

@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())``

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

X axis in the graph, there are Weeks,

2020-21, 2020-22, 2020-23, 2020-24 . . . . .

i want to colour 2020-38.

Super User

@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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

@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

Super User

@colourfullife Thinking:

``Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())``

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

Hi @Greg_Deckler for how, it shows 2019-38 and 2020-38 for dot..

Super User

@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())``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

I honestly have no idea of this dax..

this time, it didn't appear?

Super User

@colourfullife Oh, wait, syntax error, missing )

``````Measure =
VAR __Date = MAX('Table'[Date])
RETURN
IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

@Greg_Deckler  oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂

Super User

@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! 🙂

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Super User

@colourfullife Hmm, so Calendar[Date] is used in you x-axis?

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

I used Week but this made up based on date like below

Super User

@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())``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Post Partisan

@Greg_Deckler  got it!

but can it become a line??

Super User

@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?  😞

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.