Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Charticulator - setting Y Axis maximum value using a measure?

I've recently started learning Charticulator, and except for a few niggles (like being unable to change a symbol color once created), I love the customisation possibilities. One thing I'd need is th...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Could you pls provide your sample .pbix file for test?Better show me your expected output.

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Do you mean that you hope the max value changed dynamically according to the slicer?

    Which filter are you using?The one inside charticulator?Or Slicer below?

    I'm a little confused about your requested output..

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for coming back to me.

      Seeing as I have multiple plots on top of each other (I know only 2 in the file I sent), I need to find a way to align the Y axis. They're all set to manually start at 0, so this side is fine, but I also want to align the max. Not via a slicer, but via a measure that would calculate the max for the chart that would have the bigger fluctuation.

      So in the screenshot you provided, how do I set the value 60 to be dynamic pls?

      IfF this isn't possible, is there a way to use a generic Y axis that I could reuse for multiple charts?

       

      thanks

      • sstockda's avatar
        sstockda
        Regular Visitor
        4 years ago

        Hey Anonymous, 

         

        Did you manage to find a solution? I want to do the same and have multiple series on the same Y-Axis - but can't find a way to make it work. 

         

        Thanks,

         

        Simon

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Anonymous ，

       

      Have you checked the max value for Y axis?

      Best Regards,
      Kelly

      Did I answer your question? Mark my reply as a solution!

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks. I'm still a noob with charticulator so I'm probably doing something wrong.

         

        Power BI's built in charts automatically adjusts the Y axis when there are multiple values displayed.

        I've not found out how to have multiple values on the same chart in charticulator, because as far as I understand you have to drag & drop a measure on the Y axis.

        So my workaround is to have multiple charts on top of each other, but obviously I need to adjust the Y axis ranges so they match.

         

        Maybe I should have asked my question differently if my approach isn't right: how do I share the Y axis with multiple measures/values? (the X axis remains the dates table)