Automatically to display the Current Month week in Visuals

[hb0135]

Hello,

We have data in which there is weekwise data and for that we want it display it by current month week to show.
And in this we donot have date column so we can filter it out.
Sample data is shown below
Can you pls help.

Week No	Availabilty
1	89
2	67
3	89
4	56
5	26
6	485
7	34
8	78
9	98
10	67
11	97
12	79
13	54
14	67
15	34
16	68
17	59
18	74
19	45
20	87
21	89
22	45
23	65
24	76
25	55
26	65
27	45
28	78
29	45
30	67
31	87
32	56

[hb0135]

Hello  Jihwan_Kim,
Thanks for the respone what i exactly need to automatically to show only July week No i.e Wk 27,28,29,30,31 and then August will come and now only August month week should be shown that change automatically and in this 
Data we only have Week No column and Availibality Column we donot have Date coloumn

Currently it is like this and we want shown below 

Beacasue this are the only week are there in month of July and when next month comes then that will month week will come here.
I have also shown the Dummy Data set sample

Regards,
Atharva 

[v-dineshya · Accepted solution]

Hi @hb0135 ,

Thank you for reaching out to the Microsoft Community Forum.

Please follow below steps.

1. Created sample table "Table" based on your data. refer below snap.

2.  Created Calculated table "WeekMonthMap". refer snap.

3. Created Calculated column "IsCurrentMonth" with below DAX code.

IsCurrentMonth =

IF (

    [Month Number] = MONTH(TODAY()),

    1,

    0

)

4. Drag the ""IsCurrentMonth"  column into visual filter and set the value as "1". Please refer output snap and attached PBIX file.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[hb0135]

Hello  v-dineshya

Thanks for the help it worked for me.But now the new issue is occur when i want to see perivious week data by clicking on slicet i donot see the data for this all is blank.
How we can see the pervious week data also here.

Regards
Atharva

[Jihwan_Kim]

Hi, I am not sure if I understood your question correctly, but I tried to get current week's data as a result of [expected result measure:]
I tried to create virtual calendar table inside the measure.
Please check the below picture and the attached pbix file.

expected result measure: = 
VAR _datetable =
    ADDCOLUMNS (
        CALENDAR ( DATE ( 2025, 1, 1 ), DATE ( 2025, 12, 31 ) ),
        "@weeknumber", WEEKNUM ( [Date], 1 )
    )
VAR _currentweeknumber =
    MAXX ( FILTER ( _datetable, [Date] = TODAY () ), [@weeknumber] )
RETURN
    CALCULATE ( SUM ( Data[Availabilty] ), Data[Week No] = _currentweeknumber )