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

Question

Hi all,&nbsp;&nbsp; &nbsp; &nbsp; 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.&nbsp;​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.&nbsp;Please solve my issue as soon as possible.&nbsp;Thanks in advance,Sai&nbsp;&nbsp;

amitchandak · Answer

Try relative date slicer. Set it on one page and copy paste on other tabs/pages, it will ask for sync, say yes.
&nbsp;
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
&nbsp;
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
&nbsp;
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
&nbsp;

v-gizhi-msft · Answer

Hi,&nbsp;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.&nbsp;Best Regards,Giotto Zhi

Forum Discussion

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

2 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

Slicer Clear Selection White