Forum Discussion
Dynamically show/hide cards based on column values
Hi All, I have a requirement as below: I have two cards ,1. Balance Available 2. Ending Balance which are two measures. Both these cards should dynamically hide and show the measures based on "Cate...
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.
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.
AbhiSSRS
Can you please confirm if you are using single card? If yes, pls do let me know how the titles are being changed dynamically
Yes this is a single card mapped to the measure. The measure changes its value dynamically so it appears as per requirement. This may be an alternative to your actual requirement of having 2 and hiding/unhiding because that is not feasible without button clicks (bookmarks need button clicks)