Need ability to lock part of axis range (min or max)

microsoft / charticulator

Interactive Layout-Aware Construction of Bespoke Charts

Other

833 stars 115 forks source link

Need ability to lock part of axis range (min or max) #172

Closed snapper911T closed 4 years ago

snapper911T commented 5 years ago

Currently we can lock the range to a hard coded max and min amount or allow it to auto range. This causes an issue with bar charts as it will auto range to show just the relevant min and max and drop the 0 axis. We need the ability to lock the axis at zero and have the maximum scale auto range depending on data

snapper911T commented 5 years ago

This deems to be more a problem for PowerBI visuals. My workaround is to create a DAX measure: Measure=0 and just add to any charticulator data axis i want to lock at 0 in addition to my other measures.

snapper911T commented 4 years ago

@zBritva can you explain how this works?

zBritva commented 4 years ago

It's the same as auto new range new for axes,

But you will able disable/enable for min or max:

zBritva commented 4 years ago

Details:

We have a chart: on creating I used values from 5 to 10

And in Power BI I have data values from 1 to 15, by default Charticulator updates min and max values for axis. In version before 1.6.0 you able only enable or disable it for whole axis.

In the new version, you can disable for max or min. When Charticulator will update only one side of axis:

snapper911T commented 4 years ago

This has fixed the issue. To lock a data axis to 0 clear the MIN range (or set to 0) on your axis settings (pic1) and just untick the MIN autoscale when exporting (pic2)