topic Re: Show top ranking Product for that month in Tooltip in Line & Clustered Column Chart in DAX Commands and Tips

Show top ranking Product for that month in Tooltip in Line & Clustered Column Chart

Tob_P — Mon, 17 Oct 2022 12:22:12 GMT

Hi there,

I have a Line & Clustered Column Chart that details Sales by Month for each Financial Year. I'm able to use my Rank X Measure to show the top Sales Amount for each month rated by the Product Name which sold the most in that month..

However I would like the Name to be output also. Not sure how to do that! Here's my RANKX dax for the Top Ranked Product Amount Measure..

Top Ranked Product Amount =

VAR

RankingContext = VALUES(Nav_Item[Product Name])

RETURN

CALCULATE([Amount Measure],

TOPN( 1, ALL(Nav_Item[Product Name] ), [Amount Measure] ),

RankingContext )

Re: Show top ranking Product for that month in Tooltip in Line & Clustered Column Chart

johnt75 — Mon, 17 Oct 2022 13:45:24 GMT

Try

Top Ranked Product Name = VAR RankingContext = VALUES ( Nav_Item[Product Name] ) RETURN CONCATENATEX ( TOPN ( 1, RankingContext, [Amount Measure] ), Nav_Item[Product Name], ", " )

In the case where there are more than 1 product ranked #1 then it will return a comma separated list of each of them

Re: Show top ranking Product for that month in Tooltip in Line & Clustered Column Chart

Tob_P — Mon, 17 Oct 2022 15:21:39 GMT

johnt75- Excellent work again John. Worked a treat!