Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DharmaChinta
Frequent Visitor

Table visual to show only current week Data By default without any filter

Hi Team,

 

Is there a way to show only One week Data By default without any filter on a table visual and based on the week selection change accordingly ? May be a DAX that just filter on the current week ? I am new to power BI and need this functionality . Thanks in advance . Currently that table has 12 weeks of data by default .

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @DharmaChinta,

Try to create a measure like this


Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
)
)


Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @DharmaChinta,

 

If you still want the slicers to work on it, you can try the measure below.

 

Measure =
VAR selectedWeek =
    SELECTEDVALUE ( 'calendar'[week] )
RETURN
    IF (
        ISBLANK ( selectedWeek ),
        CALCULATE (
            SUM ( 'table'[value] ),
            FILTER ( calendar, WEEKNUM ( 'calendar'[date], 2 ) = WEEKNUM ( TODAY (), 2 ) )
        ),
        CALCULATE (
            SUM ( 'table'[value] ),
            FILTER ( calendar, WEEKNUM ( 'calendar'[date], 2 ) = selectedWeek )
        )
    )

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @DharmaChinta,

 

If you still want the slicers to work on it, you can try the measure below.

 

Measure =
VAR selectedWeek =
    SELECTEDVALUE ( 'calendar'[week] )
RETURN
    IF (
        ISBLANK ( selectedWeek ),
        CALCULATE (
            SUM ( 'table'[value] ),
            FILTER ( calendar, WEEKNUM ( 'calendar'[date], 2 ) = WEEKNUM ( TODAY (), 2 ) )
        ),
        CALCULATE (
            SUM ( 'table'[value] ),
            FILTER ( calendar, WEEKNUM ( 'calendar'[date], 2 ) = selectedWeek )
        )
    )

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MFelix
Super User
Super User

Hi @DharmaChinta,

Try to create a measure like this


Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
)
)


Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

To add also the current year:

Measure = CALCULATE ( SUM ( Table[Column] ); FILTER ( ALL ( Table[DateColumn] ); WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () ) && YEAR ( Table[DateColumn] ) = YEAR ( TODAY () ) ) )

Thanks a lot! 

Sorry I deleted your answer by accident

Is it possible have sales till yesterday instead till today?

Hi,

Subtract 1 from TODAY() i.e. TODAY()-1 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Is this also possible for the current week and the current year? I have multiple years.

Hi @Anonymous 

 

You need to add the year to the filter part of the measure:

 

Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
&&
YEAR ( Table[DateColumn] ) = YEAR ( TODAY () )
)
)

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.