Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • AbhiSSRS's avatar
    AbhiSSRS
    5 years ago

    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's avatar
    AbhiSSRS
    5 years ago

    Probably you are missing a relationship between the tables in model.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

You can achieve that by using 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi aj1973 

     

    could you please help provide more details as to we can achieve this using bookmarks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.