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.

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

Greg_Deckler , its 2 different table.

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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

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

      amazingly perfect.

      change relationship to both and it totally solved my problem.

      thank you very much!