Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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...
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.
Schedule a short Teams meeting to discuss your question
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.
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |