Forum Discussion
Graphics Questions
Hello All,
I did a basic base and put just four columns (Type, Data, Region, Quantity). At "type" is divided in "Forecast" and " Invoiced".
With this information I did this poor Chart of Stacked Columns and Rows.
What I would like is to put "Forecast" in the rows and "Invoiced" in the columns.
Someone knows if is possible? Or Do I need to do a column just for "Forecast" ans other just for "Invoiced" (in the base data)?
Sorry about some mistakes, and Thanks for help!!!
Israel
11 Replies
Change it to the visual called "Line and Stacked Column Chart". What you will need is a measure that simply handles the forecast portion, these will need to be placed into the "Line Values" area. Next you'll need a measure to calculate the invoiced figure, which you can then place into the "Column Values" area.
- Thanks Ross for help me. One thing: how can I put the "measure that simply handles the forecast portion"? Because I don't know how I can separated the "forecast" and "invoiced" portions that are in the same column. I just say that I must to put "forecast" portion at "column area" and "invoiced" portion at "line area". Could you have one suggestion for this case?
In the example you provided, your graph is already separating out the forecase compared to the invoiced. This means you have some piece of data, line by line, that indicates which column a given value will be counted in. What you need to do is write a measure the sums up only the values of that given circumstance. An example might be that your data contains a column that states whether its Invoiced or Forecast. If that was true, you could write a measure like:
Forecast = CALCULATE( sum('YourTable'[Amount]), 'YourTable'[Type] = "Forecast" )
