tooltip on text of chart - x-axis

[Anonymous]

Hello,
I have a stacked column chart.
X-Axis is showing field1 values which is fine.
When I hover over the bars, I get a tooltip of field3 which is good. Field3 is legend also.
Question.
Because some bars are very short, I am unable to click on the bar to see tooltip of field3 but I would like to be able to click on the x-axis texts for each bar and see a tooltip of field3. How can I do this please?
Thank you

[amitchandak]

@Anonymous , not very clear, You can give start value and end value , to make sure they are bigger

[Anonymous]

As you see in screenshot attached, there is a column chart. 

Question is on the default tooltip.
At present, hovering over the texts in the x-axis, the tooltip just shows the text.
If hovering on one of the tall bars, the tooltip shows the three fields i.e. field1, field2, field3

But the issue is :

1-

Can not hover over the very short bars and so no tooltip, therefore to make the short bars to look taller, is there a way to make the chart to have something like a break line where it splits the tall one to half or something like that so that short bars look taller?

Thank you

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

For your first question, you try to modify the 'Scale type' property.

For your second question, you try to use the picture shown below.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I can only see one scale Type option which is Linear

[Anonymous]

And the other question is, how can I make the x-axis in order of ID in table because at present, it is orderd by value of the bars? thank you