Forum Discussion

dpombal's avatar
dpombal
Post Partisan
7 years ago

Scatter Chart Y axis end

  I am having visual problems with scatter chart, I have 0 as start value for X , Y axis.  However X,Y max values is empty since  a priori I don't know the maximum value,  when powerbi manages max v...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi dpombal

Is my understanding right?

Below is a test example

In power bi, create calculated columns

new axis = IF([axis]=CALCULATE(MAX([axis]),ALL(Sheet1)),[axis]*1.1,[axis])

new ayis = IF([ayis]=CALCULATE(MAX([ayis]),ALL(Sheet1)),[ayis]*1.1,[ayis])

 

Best Regards

Maggie

 

  • dpombal's avatar
    dpombal
    Post Partisan
    7 years ago

    Hi, thanks for your reply

    Data view

     

     

    Scatter view, ....but on Xaxis start and end  (smae Yaxis start,end) I cannot drag any fields... (like new calculated columns...)

     

     

    Regards

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi dpombal

      but on Xaxis start and end  (smae Yaxis start,end) I cannot drag any fields

      for Yaxis, you could only enter values in, it doesn't support any column or measure.

      If you want to add values in these field, just type the number.

       

       

      the new created columns are used to put in the Xaxis or Yaxis fields in the visual.

       

      Best Regards

      maggie

       

      • dpombal's avatar
        dpombal
        Post Partisan
        7 years ago

        This is weird...plotting not current values, it is not valid for me , thanks at all