Sorting by text

[Anonymous]

I have a Multirow card which shows The no. of  Job Losses and the name of a company. This is set so that the company with the maximum number of job losses within the dataset is shown  (using maximum).

Within the data I have a field which refers to the reason for the job losses, Somewhere on the report page preferably next to the card I wan't to show the reason, but there are also filters which make the card change companies (e.g. Sector, UK Region) and therefore the reason for job losses would change.

In Excel I'd use a lookup, but I can't figure out a way of doing this in PBI, I've tried adding the field to the card, but it doesn't look right as the text needs to be big for the number, but the reason is a full sentence. Please help as I feel like I wasted far to much time trying to do this.

[parry2k]

@Anonymous may be you can use a card visual and use that instead of multi-row card and show reason in a table. I;m still fully not clear about the question, so if you can share sample data with expected output, it will help to get the solution.

[Anonymous]

Hi, I have gone down the table route for displaying the Reason, so I guess my question is how can I get the table to only show the Reason relating to the Company in the Card visual and also change when the filters are used and the card changes

[parry2k · Accepted solution]

@Anonymous I assume there will be multiple rows for reasons, if yes then table visual is the best approach. Not sure if Card visual is recommended visual for it.