How do I flip the x axis on a vertical bar chart?
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
-
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
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
1
Answers
-
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
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
1 -
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:
0 -
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! ✔️**1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive