Forum Discussion
Sorting by text
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.
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.
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.
3 Replies
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 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.