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

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

        Hi dpombal

        When i add the number which is max value *1.1 in the End field of X-axis or Y-axis, X-axis or Y-axis on the visual would change according to it.

         

        If my reply helps you, could you accept it as a solution, so others may refer to it when happening to the similar problem.

         

        Best Regards

        Maggie