I have a date column.I want to create a slicer for Week View/ monthly view.

[asheyashey]

As title says.
I also have one column with just WeekNos.

The weekly view should consist of only the next week.( eg 1-10-2025 is week no 40.So it should show only week no 41 data.)
The monthly view to show normally month wise.

I was thinking of using New parameter in modelling to create it but hit a blocker with the next week criteria.

[v-karpurapud]

Hi @asheyashey 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @rohit1991 and @lbendlin  for offering helpful suggestions.

Could you let us know if the suggested solution resolved your issue?If you still need help, please share more details so we can assist you further.

Thank you.

[lbendlin]

Weeks and Months are generally incompatible.  Your best approach will be an externally maintained Calendar table where you clearly spell out what week (of the year or the quarter or the month) you want each day to be in.

[asheyashey]

I tried that but even then im stuck in a blocker.
I tried creating a custom blocker showing Next week dates only but even then there is blank values column which I cant remove as i also have months slicer also to consider.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[asheyashey]

Just updating was still facing some issue and i went with the button and bookmark route.

[v-karpurapud]

Hi,

Thank You for the update. If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.

[lbendlin]

Weeks and Months are generally incompatible.  Your best approach will be an externally maintained Calendar table where you clearly spell out what week (of the year or the quarter or the month) you want each day to be in.

[rohit1991 · Accepted solution]

Hi @asheyashey 

Could you please try below Steps:

1. Sample date table I used to solve the problem.

 

2. Create Table

ViewSelector = 
DATATABLE(
    "View", STRING,
    {
        {"Weekly View"},
        {"Monthly View"}
    }
)

3. Create Measure

ShowData = 
VAR CurrentWeek = WEEKNUM(TODAY(), 2)   // Today = 1 Oct 2025 => Week 40
VAR NextWeek = CurrentWeek + 1          // NextWeek = 41
VAR SelectedView = SELECTEDVALUE(ViewSelector[View])
RETURN
SWITCH(
    TRUE(),
    SelectedView = "Weekly View" && SELECTEDVALUE('Sheet1'[WeekNo]) = NextWeek, 1,
    SelectedView = "Monthly View", 1,
    0
)

4. Drag the ShowData measure into the visual-level filter.
Set the filter condition → ShowData = 1.

[asheyashey]

I tried it but im getting an empty chart while doing this. Can you please give me a more detailed explaination,