Forum Discussion

Lolo_2023's avatar
Lolo_2023
Frequent Visitor
1 year ago
Solved

Week Number Filter Shows Full Month Data Instead of Weekly Breakdown

Hi experts, I need some help with a Power BI report. I have an Excel file that includes the following columns: Department Patient Visits No Show Month Week Number   My goal is to display the...
Need Help
  • Cookistador's avatar
    Cookistador
    1 year ago

    Hi Lolo_2023 

     

    First, add a colum to retrieve the weeknum of the first day of your month and then add the week number -1

    You can convert your month column into date or create a new column and convert it into date, then use the following calculated column:

     

    WeekNumber = WEEKNUM(RawData[Month]) + RawData[Week Number] - 1 
     
    Now, you can use your weekNumber as a slicler

     

    Ps: I joint a pbi files with the sample your shared with us

     

    Do not hesistate if you need more support

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi Lolo_2023 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

 

v-sshirivolu's avatar
v-sshirivolu
Community Support
1 year ago

Hi Lolo_2023 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    1 year ago

    Hi Lolo_2023 ,
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.