Forum Discussion

JayRags's avatar
JayRags
New Member
1 year ago
Solved

Stacked Back for Ranks

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 ...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.