Forum Discussion
How to set separate Y-Axis ranges for single-column small multiples chart?
I am looking to make a small multiples chart across four sales categories that have very different ranges. I'd like to avoid breaking these into separate charts, but I can't figure out a way to make the Y-axis relative to the range for each dimension.
I've created a measure that accurately returns the MAX value along year for each of these categories, but that does not return the correct axis result. The formula is of the format:
Max Across Years = CALCULATE( MAXX( SUMMARIZE( 'Table', 'Table'[Date].[Year], "Annual Amount", SUM( 'Table'[Value] )), [Annual Amount] ), ALLEXCEPT('Table', 'Table'[Metric Name]) )
9 Replies
- amitchandak
Super User
Anonymous , You can try small multiple for this , with setting 1 column and 3 rows
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples
Thanks amitchandak. I am using that visual with that configuration, but each Y-axis is set to the same range. Should this automatically set independent axis ranges for each dimension used for small multiples?
If that is not automatic, do you know how I can use a formula to properly set the end of the axis to be relative to the max value along each row in the chart image I pasted above?
v-kelly-msftCommunity Support
Hi Anonymous ,
You could click the setting button on the right upper corner>scale>choose "Individual Scale":
And you will see the different Y-axis range:
Check below link for reference:
https://xviz.com/blogs/advanced-trellis-small-multiples-key-features-power-bi-visual/
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
