cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Measures in X-axis of bar chart

I have data with all measures like below, how can I create a simple bar chart with column1, column2, column3 is X-axis and the sum of the values in Y-axis

 column1 coulm2 column3 1 1 7 2 2 8 3 3 9 4 4 4 5 0 5

Another chart needed is stacked bar chart (X-axis of Sold and Remaining Capacity reflecting Total Capacity.

 Resource Pool Manager Total Capacity current calendar month Sold current calendar month Remaining  current calendar month Total Capacity current calendar month +1 Sold current calendar month + 1 Remaining Capacity current calendar month + 1 Product 1 100 42 58 110 35 75 Product 2 100 42 58 110 35 75 Product 3 100 42 58 110 35 75 Product 4 200 142 58 210 135 75 Product 5 200 142 58 210 135 75 Product 6 200 142 58 210 135 75 Product 7 300 242 58 310 235 75 Product 8 300 242 58 310 235 75 Product 9 300 242 58 310 235 75 Product 10 400 342 58 410 335 75 Product 11 400 342 58 410 335 75 Product 12 400 342 58 410 335 75 Product 13 400 342 58 410 335 75 Product 14 500 442 58 510 435 75 Product 15 500 442 58 510 435 75 Product 16 500 442 58 510 435 75 Product 17 500 442 58 510 435 75 Product 18 600 542 58 610 535 75 Product 19 600 542 58 610 535 75
14 REPLIES 14
Highlighted
Anonymous
Not applicable

## Re: Measures in X-axis of bar chart

A question for clarification: What does one row represents?

Highlighted
Frequent Visitor

## Re: Measures in X-axis of bar chart

Hi @Anonymous, please see the updated table. Hope this helps.

 May June July Product A Sold 1 1 7 Product B Sold 2 2 8 Product C Sold 3 3 9 Product D Sold 4 4 4 Product E Sold 5 0 5
Highlighted
Anonymous
Not applicable

## Re: Measures in X-axis of bar chart

Thank you for the reply. I might have a solution, but I need to know more.

Could you possibly share the report or data with me?

Highlighted
Frequent Visitor

## Re: Measures in X-axis of bar chart

Thank you @Anonymous. I will not be able to share the actual data, but it basically Products solds every month. The expected report is a bar chart showing Months in X-axis and sum of values in Y-axis. Products are not required to be shown in the chart.

Highlighted
Anonymous
Not applicable

## Re: Measures in X-axis of bar chart

@SillyJam123 I understand. My solution depends on how the data is stored. Could you provide an example of it then?

If the data is stored like this, with these columns: [Date], [Product], [Value], you can just plot it into a bar chart, where you have date on the x-axis, value on y-axis and product in the legend.

If your data is stored differently, please let me know. The goal would then be to make sure it's stored this way. Or go in a different direction.

Best

Martin

Highlighted
Frequent Visitor

## Re: Measures in X-axis of bar chart

That's correct. Data is stored the way I have mentioned. But when I use Column chart, I dont get separate bars. May I have your email address I can send you the chart I am getting v/s what is expected

Highlighted
Anonymous
Not applicable

## Re: Measures in X-axis of bar chart

Absolutly, my e-mail is: martin@valubi.dk. I think I know how to solve your challenge. I will be awaiting your e-mail.

Highlighted
Microsoft

## Re: Measures in X-axis of bar chart

@SillyJam123 wrote:

Hi @Anonymous, please see the updated table. Hope this helps.

 May June July Product A Sold 1 1 7 Product B Sold 2 2 8 Product C Sold 3 3 9 Product D Sold 4 4 4 Product E Sold 5 0 5

@SillyJam123

You may unpivot the data at first.

Then get a table as below

After that it would be easy to create a visual as below.

Highlighted
Anonymous
Not applicable

## Re: Measures in X-axis of bar chart

@Eric_Zhang

@SillyJam123 and I have corresponded by e-mail. though a good solution, this is not exactly the end goal. I'm not sure if I'm allowed to share a pitcure of the end goal. But basically it is to have one bar for sold current month and one for sold current month +1. Then also have a stacked bar chart, with one color for sold and different color for remaining. It isn't clear from the post itself, and you would probably need the data to realize this as well. I'm writing with @SillyJam123 by e-mail at the moment to figure out what the we have to do to accommodate the end goal.