KNOWLEDGE BASE

How to show exact days for selected month on X axis and the line graph is blank for days after the selected date


Published: 13 Dec 2022
Last Modified Date: 15 Dec 2022

Question

How to show exact days for selected month on X axis and the line graph is blank for days after the selected date
User-added image
User-added image
 

Environment

  • Tableau Desktop 

Answer

1. Create a calculated field "parameter date": IF MONTH([Order Date]) = MONTH([Select Date]) THEN [Order Date] END

User-added image

2. Drag MONTH(parameter date) to Columns shelf and Filter card. Filter NULL values.

3. Enable "Show empty columns" checkbox.

User-added image
 
 
Did this article resolve the issue?