Clustered Column Chart - Y-Axis in 10% increments.

[collinq]

Hi all,

Very frustrated about this one and can't seem to figure out how to do it.  I have tried a couple of the other (free) clustered column charts and can't get those to work either.  Any help would be most appreciated.

I have a Clustered Column Chart (it has to stay clustered column chart but I am willing to do clustered with line if I can make the line not show and it does what I want).  I have a range of percentage values from -100% to 100%.   The visual looks fine except for the Y-Axis scale.  It auto scales to -100%, -50%,0%,50% and 100%.  I want to see the scale in 10% increments (ie. -100,-90-80, etc up to 100).

I am using the June 2023 version of Desktop.  I did find some previous notes about "using the tick marks" and changing the "display units" but as of this version of Desktop, Display Units are hardcoded and "tick marks" doesn't exist.

I have tried the zoom slider and it won't help me either for some weird reason (I think it has to do with the negative percentage part).  Also, logorithmec does not work when you have negatives.

Any thoughts?

[TomMartens]

Hey Colin,

I consider the custom visual "Deneb" (https://deneb-viz.github.io/) the best fit for this challenge.
Some sample code:

{
  "data": {"name": "dataset"},
  "layer": [
  {
    "mark":{
      "type": "bar"
    },
    "encoding": {
        "x": {"field": "Year", "type": "nominal"},
        "xOffset": {"field": "Cluster" },  
        "y": {
          "field": "amount", "type": "quantitative",
          "scale": {"domain": [-100 , 100]},
          "axis": {
            "tickCount": 21
          }
        },
        "color":  {"field": "Cluster", "type": "nominal"}  
    }
  }  
  ]
}

The result:

Next to all the amazing data visualizations, you can create with Deneb and for this reason vega and vega-lite, it allows fine-grained control of almost everything like the tickmarks.

From an organizational point of view it's super duper extra plus that the visual is certified.

Here you will find the pbix that hosts the sample: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EcYsiCXaZClDlu2C4HojgggB8OGdD...

Hopefully, this provides an idea on how to tackle your challenge.

Regards,

Tom

[collinq]

Thanks @TomMartens , I will give that a try.