Stacked Back for Ranks

[JayRags]

I have the following data :

Product	Rank	Amount
A	1	100
B	1	100
C	2	150
D	2	150
E	2	150
F	3	200

I want to plot on X axis Rank, Y Axis Amount. And at the intersection (For example Rank 1, Amount 100, show A/B, for Rank 2, Amout 150 show C,D,E). 

Can you please suggest visual for this?

[v-zhouwen-msft · Accepted solution]

Hi rajendraongole1 ,thanks for the quick reply, I'll add more.

Hi @JayRags ,

Regarding your question, I think you can use the line chart and tooltip page.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Place a card visual in the tooltip page and create a measure using the following expression

Measure = CONCATENATEX('Table',[Product],"/")

Final output

Best Regards,
Wenbin Zhou

[JayRags]

This is Perfect!!! 

[rajendraongole1]

Hi @JayRags - To visualize your data where you plot Rank on the X-axis, Amount on the Y-axis, and display the corresponding products at the intersection, you can use Power BI's Scatter Chart. The Scatter Chart allows for the plotting of distinct points with labels at the intersections, which is ideal for showing multiple products at the same coordinate.

ProductConcat_m =

CONCATENATEX(

  FILTER(

    prop,

    prop[Rank] = MAX(prop[Rank]) &&

    prop[Amount] = MAX(prop[Amount])

  ),

  prop[Product],

  "/"

)

you can also check the matrix visualization. 

Hope it works.