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
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