Forum Discussion
Hide Selection but actually use data
Hello everyone,
I need help creating a visual that compares the sales of Fiscal Year (FY) and Fiscal Year-1 (FY-1). Currently, I am using a slicer, and the idea is that when I select FY23, the visual should display sales data for both FY23 and FY22. However, what happens is that only the FY23 numbers are displayed, and FY22 appears blank. To have both FY23 and FY22 numbers displayed, I need to select both FY23 and FY22.
Is there a way to customize the visualization so that selecting FY23 will display FY23 and FY23-1, and selecting FY22 will display FY22 and FY22-1?
Thank you.
8 Replies
FreemanZSuper User
hi jzhao ,
Try to feed the FY slicer with an unrelated new table and reference the captured value with SELECTEDVALUE in your measure.
it seems the slicer is both selecting the FY23 and filtering your measures. Blank means there is nothing satisfies both FY22 and FY23.
So try to 1) feed the slicer with an isolated new table; 2) or remove FY filter context in your measure - this could be complicated.
check this for more info:
https://www.daxpatterns.com/parameter-table/
Upon further checking, the fiscal year slicer changes the source data used in measures. Is there a way to change its behavior so that instead of selecting data for FY23, it selects data from the beginning to FY23?
- FreemanZ
yes, by removing FY filter context in your measure.
how does your measure look like?
