Forum Discussion
Card visual show data only when filtered
Good day,
I'm facing a difficulty on my report page. I have some data for amounts in 2022 and 2023 shown in a matrix. I have two measures, one for the total and one to show the amount based on the same period in last year. See picture below.
However, when I dont make a selection of filters or click on a cell, the last year value is showing data, and I want it to only have a value visible when I have made a selection for a period. Is this, and if yes how can I arrange this? Thank you!
1 Reply
Hi Anonymous try to solve it with IF and ISFILTERED, like
New measure for your card (or change current one with)
New measure test=
IF(ISFILTERED(<YourTable>[ColumnName]=[YourMeasureName],BLANK())https://learn.microsoft.com/en-us/dax/isfiltered-function-dax?WT.mc_id=DP-MVP-4025372
