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.
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?
Solution SagePlease see if this would help :
The card is mapped to a measure :
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- AbhiSSRS
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)
- AbhiSSRS
Map the Title text to field , it will change dynamically based on selection