Forum Discussion
Multi-Row Card Display Help
I have a two-part issue. I am using two cards, connected to a filter, to display data on my dashboard. One card is a single row while the other is a multi-row. When no selection is made, I am using the following formula to ensure the card comes up blank:
IF(ISFILTERED(Personnel [NAME]),MAX(Lang[TYPE]),Blank()&””)
This works for both cards; however, when a selection is made for the multi-row card, only one result is returned as opposed to all possible values. I am sure that this is because of the MAX portion of the formula, however, I do not know what I should be using instead.
For the second portion of this equation, I have a single card that is supposed to return the date an individual started working; however, with the MAX portion of the formula above, it returns 12/31/2020 for the max date as opposed to the correct date the individual started.
Can anyone help me with these two issues? How to return all possible results for the multi-row card, and how to return the correct start date for individuals.
8 Replies
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? and explain the output with sample data
Unfortunately, I don't have access to BI right now, but I attempted to make an excel example of what I mean. Both tables are connected via the personnel number and when a name is filtered, the text boxes to the right of the tables displays what I need to see. As I mentioned though, I am not seeing the right date, or the multiple selections for the multi-row card. I hope this helps!
- Pragati11
Hi Anonymous ,
- What is the format of your date column that you are displaying on a single card?
- for the multi-row card, I think you are using Language column, which can have multiple values against a Person.
- What is the relationship between these two tables?
- On which column the relationsip is made?
- What is the direction of the relationship?
Thanks,
Pragati
