Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gcv1999
Helper I
Helper I

Measure Visualization by Week

Hello,

 

I have a measure showing the value in a visualization like this: 

 
Overdue = CALCULATE(COUNT(Table[Overdue]), Table[Overdue] = "overdue") + 0
166aea9765b02cf133b6df18a497f05f.png
The table that this measure draws from has various date columns that I think would be involved in my answer.
 
What I would like to show is this measure's value, but how it changes by week, like this:
Picture1.png
Is there any way that I can do this? I have thought about adding a table that contains a list of dates then tying it to the parent table someway, but I am unsure if that would work or if there is a better solution.
 
Thank you
1 ACCEPTED SOLUTION

Hi @gcv1999 ,

It could be related to your Power BI version.

Mine is: 2.80.5803.1061 64-bit (April 2020)

 

I've just downloaded the file and opened it without problems.

Can you try using the latest version?

Cheers,

Marco

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@gcv1999 , Typically Overdue is as on date. If it can work with past dates. Then you can have a date table and create a Week Number like

Week ="WW" & Week Number = WEEKNUM([Date],2) //Monday Week

Week ="WW" & Week Number = WEEKNUM([Date]) //SundayWeek

 

Or like

Week Number =WEEKNUM([Date],2)

Week  = "WW" & if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])

MarcoPessina
Resolver IV
Resolver IV

Hi @gcv1999,

you can achieve it adding a Date table, creating a relationship with your table and using the measure you have created.

Annotation 2020-05-13 122000.jpg

Try this:

https://1drv.ms/u/s!AqOXkXXQjzm4bYGECHgAE1jhqgc?e=IV1FKv

 

Hope it helps.

Cheers,

Marco

Hello Marco,

 

Whenever I try to open your file I get an "Object reference not set to an instance of an object" error

 

Thanks for helping

Hi @gcv1999 ,

It could be related to your Power BI version.

Mine is: 2.80.5803.1061 64-bit (April 2020)

 

I've just downloaded the file and opened it without problems.

Can you try using the latest version?

Cheers,

Marco

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.