Hide the first periodOverPeriodDifference Value in a visual sheet

Question & Answer
, ,
1

Hi Team,
Currently, I have one time control for users to choose the specific month end (eg 2025/05/31) and I could select the corresponding Last 2 Months to calculated the MoM Difference
use formula: “periodOverPeriodDifference(count({Customer}), {Month End}, MONTH, 1)”
for 2 consecutive month-end values (eg. 2025/04/30 vs. 2025/05/31).

image
image711×970 84.9 KB

Here is my question: I find that the Diff by Month for “Apr 2025” is null because I previously filtered only “Last 2 months” to calculate the MoM Difference and no “Mar 2025” Data was filtered in (please refer to the two red rectangle above).

How could I hide the null part (i.e “Apr 2025” Part ) and show the current one month only (i.e “May 2025” Part) in this visual without changing my filter conditions?

Thanks for your help in advance~

2

On the other words, I want to know how to visualize some value of a row (“May 2025”) and hide other value one (“Apr 2025”) without changing the filter conditions in QuickSight.