Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

If has one value not working

Hi all,

 

i have a table visual with a list of account names and I am using a card visual to show what account name is currently selected but its not working properly. For example, I am using:

 

   dynamic Header = IF(HASONEVALUE('mydata'[accountname]),

"Account - " & values('mydata'[accountname])) , "Select Account Name" 
 
for some reason when you select an account name from the slicer the output is correct, but if you click on an account name in the table visual the output is unchanged. Why is that? Is there a way around this?
 
Thanks
  
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous It's hard to say without knowing what your data really looks like. Might be possible using something like ALLEXCEPT or REMOVEFILTERS or something like that.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous First, make sure that your table visual is cross filtering your card visual using Format | Edit Interactions

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Greg_Deckler  I just realized the issue is with the FY QTR value in the table visual, when I remove FY QTR it works. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Greg_Deckler  is it possible to keep the FY QTR from causing this issue?