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. ;)
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
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!