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 ,

 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi sstockda 

         

        I'm afraid no. Another project has taken priority so this has been left for now.

        I'm thinking of whether I should create a measure that calculates axis elements up to the maxmum of all series and use this as a Y axis (pretty much the way the date axis is separate from each measure annd pulled from a separate Dates table) but not sure how to ensure each value exists in the Y Axis values table...

        Do post an update here if you manage to achieve "our" goal 

  • 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)