Forum Discussion
Dynamically show/hide cards based on column values
Please see if this would help :
The card is mapped to a measure :
Measure = IF(LOOKUPVALUE(Sheet2[Column2],Sheet2[Column1],SELECTEDVALUE(Sheet1[Category]))="Ending Balance",SUMX(Sheet1,Sheet1[EndingBalance]),SUMX(Sheet1,Sheet1[BalanceAvailable]))The card visual's title is mapped to Category as well.Probably you are missing a relationship between the tables in model.
Solution SageHello!
isn't this feasible with a measure on selected value for Category for you? The Label will default to the selected Value with no need to hide/unhide
Am I missing something here?
Hi AbhiSSRS
Please note that there is not slicer for the "Category" field, this field is getting filtered based on the other slicers available.
Is there a way to achieve this? As there are two measures to be shown dynamically.
- AbhiSSRS
It would still work! the selected value for the control which shows 'Category' will automatically show up the corresponding value on the card visual. Like when BSF is selected(based on other selections as you mentioned) it would display Ending Balance in the Card.
AbhiSSRS I will try this out and let you know asap.
AbhiSSRS
Tried to replicate the same but could not achieve, below is the sample data.
Is possible, can you suggest the solution with the data given here?- AbhiSSRS
Please see if this would help :
The card is mapped to a measure :
Measure = IF(LOOKUPVALUE(Sheet2[Column2],Sheet2[Column1],SELECTEDVALUE(Sheet1[Category]))="Ending Balance",SUMX(Sheet1,Sheet1[EndingBalance]),SUMX(Sheet1,Sheet1[BalanceAvailable]))The card visual's title is mapped to Category as well.