Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I created this dashboard with scores for companies classified by industry. When I select an industry in the upper left corner, the cards below show me, among other fings, the minimum and the maximum score in the selected sector. I would like to show as well who is the company with the minimum and the maximum score.
I guess that is something like this:
Click on the "Worst company" card > visualizations > quick measure > ... and then I do not know what to do!
Could you help me, please?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
hi @gsandrade
showing the item corresponding the max value is just one step further. please paste some sample data including the value- and item-relevant columns.
Dear Freeman, thank you for your reply.
The company card only allows me to show First, Last, Count (Distinct), or Count. Regarding the min and max scorecards, they are working well.
I would like to show the company name related to the min and to the max scorecards. By now, the company cards are just showing the "First" (which is the first company in the list A>Z).
Please, follow the image below for some data. The average score is the average of the 5 left columns. The minimum scorecard shows the min of the average score.
Hi,
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result very clearly.
Dear,
I attached the sample on Drive:
https://docs.google.com/spreadsheets/d/1KpB-Pfa4Tz_FEFAd04_piZxSbzTU7PfJ/edit?usp=share_link&ouid=10...
With this sample, the expected result is a card showing Microsoft as the worst company (lowest average), and another card showing NVIDIA as the best company (highest average).
Kind regards.
Hi,
You may download my PBI file from here.
Hope this helps.
hi @gsandrade
try to plot the cards visual with two measures like:
MinComany =
VAR _minavg = MIN(TableName[Average])
RETURN
MAXX(
FILTER(
TableName,
TableName[Average] = _minavg
),
TableName[company_name]
)
MaxComany =
VAR _maxavg = MAX(TableName[Average])
RETURN
MAXX(
FILTER(
TableName,
TableName[Average] =_maxavg
),
TableName[company_name]
)
it worked like:
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |