How do I flip the x axis on a vertical bar chart?

Options

I have a vertical bar chart that has a goal of 25. The user is confused because the goal is "anything under 25 is good" but with how the chart looks it looks like you are trying to reach 25 because the goal is set at the top of the card.

Is there a way to flip it so that the x axis is at the top of the card and thus makes it so the bars are coming from the top instead of the bottom?
This way the goal would be situated under the x axis not on top of it.

I want it to look like it would if I had negative numbers for my data (only the data is not negative numbers, I just want the layout the same).

Best Answers

  • MarkSnodgrass
    Answer ✓
    Options

    You could create a beast mode that multiples your number by -1 and then put that beast mode in your x-axis. The numbers will display as negative, but it would give you the look you are going for. You could also hide the scales so that the negative numbers don't appear on the x-axis, which might help with the look.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ColemenWilson
    Answer ✓
    Options

    Agree with what @MarkSnodgrass has said. I would add that you could use color rules that when the value is under 25 it is green and when it is above it is red, etc…

    If I solved your problem, please select "yes" above

Answers

  • MarkSnodgrass
    Answer ✓
    Options

    You could create a beast mode that multiples your number by -1 and then put that beast mode in your x-axis. The numbers will display as negative, but it would give you the look you are going for. You could also hide the scales so that the negative numbers don't appear on the x-axis, which might help with the look.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ColemenWilson
    Answer ✓
    Options

    Agree with what @MarkSnodgrass has said. I would add that you could use color rules that when the value is under 25 it is green and when it is above it is red, etc…

    If I solved your problem, please select "yes" above

  • Takalla
    Takalla Member
    Options

    I ended up just making them negative numbers and then using the ($0.00) format since I have other cards on the same dashboard that are actually negative numbers and they're using the -$0.00 format.

    The idea of using red and green is actually a very good one and I would've rather just used that to solve this but we're using our brand colors on the bar colors so unfortunately that isn't an option in this case.

    Thank you both!

    Picture of solution:

  • david_cunningham
    Options

    One thing you could do is to use a tooltip and wrap your value inside ABS() in beast and then display that tooltip. That way the values you display will be positive, but the chart will still be inverted like you are looking for.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**