Forum Discussion
Display two values for each date on stacked column chart
- 7 years ago
If your table looks like this
I don't know why it didn't work on your side
Since I cannot reporduce your issue, I hope someone can help you.
Have a nice day!
- 7 years ago
U need to create 2 measures using this colums and use it in visual.
In your case it will be
Measure 1 = SUM(Column 1)Measure 2 = SUM(Column 2)
And U need to use "clustered column chart" not stacked. ;)
This might be possible if you will elaborate what you really need
I have table with 5 olumn : date, cost1, cost2, revenue1 and revenue 2 need to dispalay costs (cost1 and cost2) in one stacked column and revenues (revenue1 and revenue2) in another stacked column for same date
- mussaenda7 years ago
Community Champion
You can drag your date to axis, drag revenues to values since your revenue 1 and 2 are in different columns. Same with your costs
- giorgi_lommidd7 years ago
Helper I
Sorry, but your suggestion did not work. Thanks fro response !
- mussaenda7 years ago
Community Champion
If your table looks like this
I don't know why it didn't work on your side
Since I cannot reporduce your issue, I hope someone can help you.
Have a nice day!