Forum Discussion

prabavathym's avatar
prabavathym
Helper II
1 year ago

Slicer Not Filtering Table Visual

Hi all, I have two tables: Date Table: Date column ranges from 08/01/2024 12:00:00 AM to 12/04/2024 12:00:00 AM. Log Table: StreamingStartTimeUTC column with the same range and format. I’ve est...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi prabavathym ,

 

I noticed that you're using the Date/Time (UTC) column in the Slicer, but you're using the StreamingStratTime column in the table visual. They are two columns from different tables, and relationships need to be created between the tables to enable filtering.

 

Depending on the date columns of the two tables, try to create a "one-to-one" or "many-to-many" relationship. If the problem persists, provide a PBIX file (no sensitive data). At the moment, I can't reproduce this issue based on the information you provided.

 

 

Best regards,

Mengmeng Li

  • prabavathym's avatar
    prabavathym
    Helper II
    1 year ago

    Hi Anonymous ,

    Thank you for your response! I’ve already created a relationship between the Date and StreamingStartTimeUTC columns. However, the slicer still doesn’t filter the table visual.

    I’ll double-check the relationship type and try creating a "one-to-one" or "many-to-many" relationship as you suggested. If the issue persists, I’ll share a PBIX file without sensitive data for further investigation.

    Thanks again for your help!