Forum Discussion

KPMEE's avatar
KPMEE
Frequent Visitor
3 years ago

Exclude 1 Column in Table (visual) from Date Slicer

Afternoon,

 

question is quite simple (hope the solution is as well):

How can I exclude one column from a date slicer in a visual table?

 

NamePerformance APerformance BPerformance CStarting date
     

 

I want Starting Date to be exclude from the slicer above 🙂

Need Help

5 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    How have to show more the visual, the relationship. In general you can prevent the interaction, select the slicer, via "Format", klick "Edit Interactions" and than disable the interaction for the table.

    • KPMEE's avatar
      KPMEE
      Frequent Visitor
      3 years ago

      Hey, 

      I don't want to disable the interaction for the entire table, only one column in the table.

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    You can only prevent it later via DAX and e.g. remove filter. You mean a column in a table not in a matrix, right?

    • KPMEE's avatar
      KPMEE
      Frequent Visitor
      3 years ago

      hey! yes correct 🙂

      • andhiii079845's avatar
        andhiii079845
        Solution Sage
        3 years ago

        I do not know how to prevent it. Later in the matrix or visual you can us dax and measure to ignore a filter.