Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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 |
---|---|
12 | |
11 | |
8 | |
7 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |