slicer not work

[space83]

I create slicer and table as below.

Unfortunately the data in table are not reflect with the slicer.

Could someone help where is I did wrong and how to resolved this issue?

I want to upload my pbix file here but seems this entry are not support to upload pbix file.

[space83]

@Greg_Deckler , its 2 different table.

slicer is from table calendar and table is from another table.

[v-yiruan-msft · Accepted solution]

Hi  @space83 ,

Do the Kalendar and Excel tables create a relationship through the field [Year/Week]? Please replace the [Year/Week] field in the table visual with the [Year/Week] field in the Kalendar table instead of the Excel table as shown in the screenshot below.

Or you can change the Cross filter direction of the two tables to Both. Please find the details in the attachment.

If the above ones can't help you, you can refer the following thread to upload your pbix file in your thread.

How to upload PBI in Community

Best Regards

[space83]

amazingly perfect.

change relationship to both and it totally solved my problem.

thank you very much!

[Greg_Deckler]

@space83 Is the Year/Week column that shows up in the slicer and the table visual coming from the same Table/Column? Also, you might want to check the Edit Interactions by selecting the slicer and then going to the View tab.