My report filters by week number. I need this filter default week to reflect the current weeks calendar week, rather than default to the last selection. How can I set this report default in Power BI?
(Visited 561 times, 1 visits today)
ksri8580 Answered question September 11, 2020
HI..
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? Maybe a DAX that just filter on the current week? I am new to Power BI and need this functionality
Try to create a measure like this
Measure =
CALCULATE (
SUM ( Table[Column] );
FILTER (
ALL ( Table[DateColumn] );
WEEKNUM ( Table[DateColumn] ) = WEEKNUM ( TODAY () )
)
)
Regards,
(Visited 1 times, 1 visits today)
ksri8580 Answered question September 11, 2020
