can I set fixed color to series in stacked bar chart?
I created a stacked bar chart card which has 5 series in it. then I assigned color to each series. but when I selected only 3 series the colors that are assigned to series would change. Is there any solution to assing fixed color to series independent if they are selected or not.
for example if we have 3 series for different cateogry of cars and their sales:
sport car --- > Red
Sedan -- > blue
SUV --- > orange
then if user selects just sport car and SUV, the SUV color becomes blue instead of keeping its original value orange.
can anyone help me to solve this issue?
Best Answer
-
Colors in KPI cards, like bar or line charts, are assigned by either the order of the column added to the card or the order of a value appearing in a particular column, but not the value in column itself.
In other words, the vehicle type "Sedan" cannot by itself always be assigned to the color red, but if "Sedan" always appears as the first value in a series and the first series is assigned to red in the chart properties, then "Sedan" will indirectly always be red. Sometimes, though, it's hard to enforce series values to always appear in the same order.
We ran into this when I was working with a particular vendor where, despite the chart type or page location, their branding portfolio required that brand X always needed to be red, brand Y always needed to be blue, and brand Z always needed to be green. Domo could be better in this regard. Search the Ideas Exchange for this feature and if it isn't there, make sure to add it.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Colors in KPI cards, like bar or line charts, are assigned by either the order of the column added to the card or the order of a value appearing in a particular column, but not the value in column itself.
In other words, the vehicle type "Sedan" cannot by itself always be assigned to the color red, but if "Sedan" always appears as the first value in a series and the first series is assigned to red in the chart properties, then "Sedan" will indirectly always be red. Sometimes, though, it's hard to enforce series values to always appear in the same order.
We ran into this when I was working with a particular vendor where, despite the chart type or page location, their branding portfolio required that brand X always needed to be red, brand Y always needed to be blue, and brand Z always needed to be green. Domo could be better in this regard. Search the Ideas Exchange for this feature and if it isn't there, make sure to add it.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
yes, thanks
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive