Table visual shows only current week data and also if i am using slicers it will shows selected data

[saikiran]

Hi all,

      If i am showing data in table visual but by default when the report will open it will show only current week data and if i want to see other weeks data i will select Year and month and week numbers that time those related data will come.

if by default it only shows the current week. 

​I mean, by default all the tabs show only this week. The user can choose Month to filter for the whole month, or year for the whole year.

Please solve my issue as soon as possible.

Thanks in advance,

Sai

[v-gizhi-msft]

Hi,

According to your description, i am confused about your requirement.

Could you please share some sample data and the expected result you want by screenshot here?

Remember to remove any sensitive data.

Best Regards,

Giotto Zhi

[amitchandak]

Try relative date slicer. Set it on one page and copy paste on other tabs/pages, it will ask for sync, say yes.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

You can also drag the date on report filter in filter pane and achieve same.

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin