Year and week slicer on all pages of report

[Anonymous]

Hi,

I want to apply year and week slicer on all pages of report. I want to use them in a seperate page. First choose the year and week then go through all the page results. In my all tables i only have year and week columns. So, not able to make two relationships active.  

Is there any solution for this?

Thank you in advance.

[amitchandak · Accepted solution]

@Anonymous , Seem like you have multiple tables. In that case create a year Week Table

Create a new column in all Table

Week Key = [Year] & [Week]

You can create week year table with Week, Year and Week Key and join all these tables with table on Week Key.

(In case you want create Year Week table from these tables -https://www.youtube.com/watch?v=Bkf35Roman8)

You can use slicer from this table. If needed, you can sync the, across page - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages

[amitchandak · Accepted solution]

@Anonymous , Seem like you have multiple tables. In that case create a year Week Table

Create a new column in all Table

Week Key = [Year] & [Week]

You can create week year table with Week, Year and Week Key and join all these tables with table on Week Key.

(In case you want create Year Week table from these tables -https://www.youtube.com/watch?v=Bkf35Roman8)

You can use slicer from this table. If needed, you can sync the, across page - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages

[Anonymous · Accepted solution]

Thank you.