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
travbum
Advocate I
Advocate I

Plotting Data Weekly

I have this data below which is collected once a week. I've tried a few differnt ways of plotting this and Power BI doesn't seem to like it. What am I missing and how can I work with this data?

 

1-Jun5
8-Jun11
15-Jun16
22-Jun22
29-Jun30
6-Jul32
13-Jul34
20-Jul37
27-Jul40
3-Aug45
2 ACCEPTED SOLUTIONS
Sean
Community Champion
Community Champion

@Sean

 

That is a lot more elegant than the solution I was attempting to work towards. Thanks!

View solution in original post

6 REPLIES 6
Sean
Community Champion
Community Champion

what exactly doesn't PBI like?

 

Weekly Data.png

I am new to Power BI and have tried to plot similar weekly data. I tried using the formula given in the post but I couldn't get it to work. Please could somebody show me how to do this so that I can show data collected on a weekly basis on a graph, and show the date rather than week number on the axis (just as in the example above)

@Sean

Thanks for the fast reply! What's going on in your table with Week?

Sean
Community Champion
Community Champion

Week = YEAR(Table[Date])&"-"&WEEKNUM(Table[Date])

https://msdn.microsoft.com/en-us/library/ee634572.aspx

@Sean

 

That is a lot more elegant than the solution I was attempting to work towards. Thanks!

Sean
Community Champion
Community Champion

@travbum Well since you said "elegant" now I feel compelled to give you the solution that will sort weeks 1 thru 9 properly

 

Year-Week =
    YEAR ( 'Calendar'[Date] ) & "-"
        & CONCATENATE (
            IF ( WEEKNUM ( 'Calendar'[Date] ) < 10, "0", "" ),
            WEEKNUM ( 'Calendar'[Date] )
        )

 

Helpful resources

Announcements
Europe Fabric Conference

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors