Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bharat7
Helper I
Helper I

Issue with bubble chart

HI,
I've an issue with bubble chart. I can't see full buble for the datapoints which are close to axis(both X and Y).I can see only half bubbles there. If I give negative values to both axis it will show complete bubble. I know we can hardcode negative values but that's not working for me.
Is there any way to give values for the axis dynamically?

 

Thanks in advance.

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @Bharat7 

 

fx  measure like the following

Start_x = MIN('Table'[X])-(MAX('Table'[X])-MIN('Table'[X]))*0.2

End_x = MAX('Table'[X])+(MAX('Table'[X])-MIN('Table'[X]))*0.2

result:

 vchenwuzmsft_0-1635819554499.png

i put my pbix file in the end you can refer. 

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

Hi @Bharat7 

 

fx  measure like the following

Start_x = MIN('Table'[X])-(MAX('Table'[X])-MIN('Table'[X]))*0.2

End_x = MAX('Table'[X])+(MAX('Table'[X])-MIN('Table'[X]))*0.2

result:

 vchenwuzmsft_0-1635819554499.png

i put my pbix file in the end you can refer. 

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Bharat7 , In the new release I think August 2021 onward. We have option of Fx In Start and End, and we can use measures there to control that

Hi @amitchandak , Thanks for the reply.
Can you  help me with the logic (in writing dax for that fx)- I am so confused as there are many slicers slicing that Visual

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.