Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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.

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous 

     

    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:

     

    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.

3 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Anonymous 

     

    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:

     

    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's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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