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.
Hi Anonymous
Maybe this video can help you better
https://www.youtube.com/watch?v=xCMqWEvSkAs
Or maybe A sample Pibx would help me show you through your model
Hi aj1973
Thanks for the video. I have understood the concept of bookmarks, but trying to understand how the bookmarks can be used the achieve my scenario where i need to show either the Ending Balance or Balance Available based on the values that are available in the category field.
Probably , could you share a pbix file if possible and that will help.thank you.
Hi Anonymous
Here is a report where i used bookmarks and drillthroughs to navigate between pages and visuals
(Sorry can't share the Pbix though)
Maybe if you can share a sample of your Pbix then i can I help you with it.
aj1973
Tried to attach the pbix file but it doesnt allow,
https://app.powerbi.com/view?r=eyJrIjoiMGVhZDgwN2MtMmU2NC00ZTY1LTg3MDktNzQ5Nzg5ZjZjOTU4IiwidCI6ImY3MWI1OGI1LTQxMjYtNDNhOS1iY2IzLTIxYzlkZTZmNTI0MSIsImMiOjN9Can you help with the solution based on the screenshots?