Forum Discussion

space83's avatar
space83
Icon for Helper IV rankHelper IV
4 years ago
Solved

slicer not work

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 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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.