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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AbhiSSRS  Tried to do the same but the text is showing as balance available always though i selected a category which has ending balance( but the numbers are changing correctly.)

 

AbhiSSRS's avatar
AbhiSSRS
Icon for Solution Sage rankSolution Sage
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    AbhiSSRS  Thank you for the detailed steps and timely responses. this helped.