Skip to main content
cancel
Showing results for 
Search instead 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

Reply
kangkopi15
Helper I
Helper I

Weekly visualization

Dear Experts,

In my previous post https://community.fabric.microsoft.com/t5/Developer/Utiisation-per-week/td-p/3730765 I was helped by @v-yiruan-msft the result was amazing.
I have now another question on how to create a visualization every week if I filter by the utilization.

kangkopi15_0-1716345913545.png

If I run a filter on the total utilization less than 70%, I expect to have this:
- on week 29/02/2024, grade 1 = 3 (Arif, Jon, Sapri), grade 2 = 4 (Bowo, else), and so on
- on week 03/03/2024, grade 1 = 3 (Arif, Jon, Sapri), grade 2 = 3 (Bowo, Joko, Supri), grade 3 = 1
- on week 10/03/2024, grade 1 = 3 (Jon, Sapri, Upik), grade 2 = 4, grade 3 = 1

and next question is, how can I visualize that on a chart?

1 ACCEPTED SOLUTION
kangkopi15
Helper I
Helper I

I managed to solve this by duplicating the table and running the group by in power-query.

View solution in original post

4 REPLIES 4
kangkopi15
Helper I
Helper I

I managed to solve this by duplicating the table and running the group by in power-query.

kangkopi15
Helper I
Helper I

hi everyone, appreciate any suggestions or pieces of advice

amitchandak
Super User
Super User

@kangkopi15 , Better create a date table with Week Date/Number in the table and Have Utilization % plot with That

Join dat if date table with date of your table

example

 

 

ADDCOLUMNS(
//CALENDAR(EOMONTH(_min, -1*month(_min)) +1, EOMONTH(TODAY(),-1))
CALENDAR(date(2018,01,01), date(2021,10,31))
,"Year", YEAR([Date])
,"Month No", MONTH([Date])
, "Qtr No", QUARTER([Date])
,"Month",FORMAT([Date], "mmmm")
, "Month Year", FORMAT([Date], "mmm-yyyy")
,"Qtr", FORMAT([Date],"YYYY-\QQ")
,"Month Year Sort", Year([Date])*100 + Month([Date])
, "Year Week No", YEAR([Date])*100 + WEEKNUM([Date],2)
, "Week No",  WEEKNUM([Date],2)
, "Week Day", FORMAT([Date], "ddd")
, "Weekday no",  WEEKDAY([Date],11)
, "Start Of Month", EOMONTH([Date],-1)+1
, "End of Month", EOMONTH([Date],0)
, "Start of Year", EOMONTH([Date],-1* MONTH([Date]))+1
, "End of Year", EOMONTH([Date],12 -1* MONTH([Date]))
, "Start of Qtr", var _rem=  if(MOD(MONTH([Date]),3)=0,3,MOD(MONTH([Date]),3))
                RETURN EOMONTH([Date], -1*_rem)+1
, "End of Qtr", var _rem=  if(MOD(MONTH([Date]),3)=0,3,MOD(MONTH([Date]),3))
                RETURN EOMONTH([Date], 3- _rem)
,"Week Start Date", [Date]- WEEKDAY([Date],11)+1
,"Week End Date", [Date]+7- WEEKDAY([Date],11)
 , "Start of FY", Date(if(month([Date]) <4,Year([Date])-1, Year([Date])),4,1)
, "End of FY", Date(if(month([Date]) <4,Year([Date]), Year([Date])+1),3,31)
)

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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