I have a visual where I am showing Monthly Active Users (MAUs). Currently, we only have data for January, February, and March. I have noticed that when I do not filter by the month alone I have different results from when I display all months. Also, when February ended the MAUs had one value and that value has now changed.
How can I lock in these values month to month so they do not change with filtering or changes in user status for months that follow?
I would have to see the workbook to know what you are doing - but it sounds like you want to use an lod and apply any filters as dimension filters not context filter - see https://jimdehner.com/2022/07/23/fixed-lods-and-how-they-are-affect-by-filters/
if that doesn't meet your need please post your workbook so we have something to work from
Thanks
Jim - Tableau Visionary
