- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top Ranked in various metrics
I have a number of current ranking measures which detail top salesperson, top selling region etc which are working well within a clustered column visual.
What I would like to do with each metric is display some additional information. So in best selling region, I'd like to display the region name (this is as a tooltip), but probably through concantenation, also display the best selling salesperson in that region and the total sales for that person. I have all these currently as measures along the lines of this...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your semantic model.
RANK function (DAX) - DAX | Microsoft Learn
TOPN function (DAX) - DAX | Microsoft Learn
CONCATENATEX function (DAX) - DAX | Microsoft Learn
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Click here to visit my LinkedIn page
Click here to schedule a short Teams meeting to discuss your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for replying and I can see that I could probably achieve an element of what I need with your solution, so thank you for that.
Here is a link to stripped back sample file
https://drive.google.com/file/d/1rCl91ci3u80OuT62kUsQgOt6lCOuxyiL/view?usp=sharing
What I would like to see if possible to achieve is utilising some of the measures I have (adpating them of course), to have the tooltip style in the first chart, blending together the best selling salesperson & team by daily sales. Unfortunately I need to keep the existing format of the tooltip as there are a number of other metrics I need to display, that cannot be superceded by the tooltip suggestion you have offered.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-07-2024 10:05 AM | |||
06-05-2025 03:49 PM | |||
07-10-2017 05:40 AM | |||
10-21-2024 10:02 PM | |||
Anonymous
| 05-10-2022 06:29 PM |
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |