Forum Discussion
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...
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] - 1Now, 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
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
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.