Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jan 25, 2022, 5:52 PM

Hiding date part for only specific year?

Hi,

 

I have a bar graph of turnover where our company recently acquired another company. As you can see it happened in Q4 of 2021. Is there a way to hide Q1 of 2021 while still displaying Q1 of 2022?

 

Hiding date part for only specific year?

2 answers
  1. DIEGO FERNANDO MARTINEZ RODRIGUEZ (Modux)
    Jan 25, 2022, 6:02 PM

    @Nicholas Madison​ 

    Hi again, in this case you can create a calc like:

    IF DATEPART("quarter",[Order Date])=1 AND YEAR([Order Date])=2021 THEN "Hide" ELSE "Show" END

    And then, you can add it to the rows shelf:

    @Nicholas Madison​ Hi again, in this case you can create a calc like:IF DATEPART(And then you can right clic on the hide label and select hide:

    imageAnd then uncheck Show Header in the pill in the rows shelf:

    imageIf this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego

    Tableau Ambassador

Write an answer...
0/9000