Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Normalization of Y axis values

I am using 2 stacked column charts similarly on the same page, 1st visual has different values and similarly having 2nd visual for different values. Here I want to normalize the Y axis values based on the 1st visual. while comparision in side by side user can able to understand the data in 2visuals. Instead of changing the max value y-axis in 2nd graph, I need that dynamically changes that based on the y axis plotting in 1st axis. is there any possibulity please help me here. Thank you so much in advance.

 

 

 

 

 

 

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your reply but my end issue not yet resolved. Can you please provide me the selected measure context how to write. my scenario it is not a text value it is a number value.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Thanks for your response, I will attached my sample PBIX file here this is the scenario. as per below reference the left side graph Y- axis value normalise with right side y-axis value that is the thing we required dynamically without chnging the Y-axis max value. user will easily understand the comparision between the 2 visuals. here you can identify the comparision both the graphs having different y-axis values come to visualization it will be the same each other.

       

      please find the below is the reference. Its highly appreciated for your help

       

      • sturlaws's avatar
        sturlaws
        Resident Rockstar
        3 years ago

        Anonymous, perhaps set the max range of the y-axis to the measure/value field for each chart individually:

         

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    Hi Anonymous 

    Please try this,

    create the measure below and put it into Y-axis

    maxvalue = SUMX(Table2,[value])+100

     

    before

    after

    Best Regards,

    Community Support Team _Tang

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Thanks for your reply, but in my scenario it was not works because in Y-axis max value is larger that time we apply the measure which you are provided the graph value is too small. based on the filter it will take the maximum value dynamically so it would be better. below is the reference

       

       

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        3 years ago

        Hi Anonymous 

        Thank you for your reply. Since I don't have your sample data, my answer is for your reference, if it has helped you to solve the problem, please accept my answer as SOLUTION, thanks.😁

        If you need more help, please let me know.

         

        Best Regards,

        Community Support Team _Tang

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