Forum Discussion

manjugoyal123's avatar
manjugoyal123
New Member
3 years ago

Bubble Chart with measures on both axis wont split vertically into 3 bubbles based on values

Hi All   I am trying to create a scatter plot in PBI Desktop for Report Server, not sure if it changes anything.   Data: My data has products categorized by brand they belong to and their unit pr...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

manjugoyal123 , You can the use Min and Max values of the axis to set this

 

You can use meausre using fx option

for x-axis

Max value = Maxx(summarize(Table, Table[Product], Table[Brand], "_1", [Rank]), [_1]) *1.1

 

Min Value = Minx(summarize(Table, Table[Product], Table[Brand], "_1", [Rank]), [_1])*.9

 

 

for x-axis

y max= Maxx(summarize(Table, Table[Product], Table[Brand], "_1", [pricerounded]), [_1])*1.1

 

y Min= Minx(summarize(Table, Table[Product], Table[Brand], "_1", [pricerounded]), [_1])*.9