Question

How can I display 2 Dimensions on X axis (bar chart)

  • 23 December 2021
  • 2 replies
  • 254 views

Hi, I am trying to create a graph with dimensions: date & name in the X axis, with some measures that are stacked.

I’d expect the visualisation to group multiple names that belong to the same date & display the date only once. But that doesn’t happen & as a result part of my x labels is trimmed if the label is too long.

what I get:

what I’d like to have:

 

Is there any way to do that in one graph? I don’t want to have the names as pivot cause then I will have multiple graphs.


This topic has been closed for comments

2 replies

@Vimal thanks for the detailed answer.

Unfortunately, this is not what I was looking for.

I am looking for a solution that would work programatically on multiple dates, and with changing data, so I can’t name the entire x axis with one specific date.

Thanks.

Hi Idan, 

This is possible with changing some custom settings in the visualization. go to visualization settings and give a custom X axis name.

under X axis tab, enter the custom axis name, in your case “ the date”

then you have to hide the date from the visualization. 

 

Then you’ll get you expected result. I hope this helps. 

once you click hide from visualization, the date doesn’t show up in our bar chart