Graphics Questions

[Rael]

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

[Anonymous]

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.

[Rael]

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?

[Anonymous]

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"
)

[Rael]

Thanks one more time Ross. I did as you said me and the expression worked but the "value" that it put as wrong (it should to put just "3" but it put other values in the "ForeCast column". I tried to understand why (and put one more filter) but didn't work.

Do you have one more idea about what I need to put at expression to work well? Attached the print. And thanks one more time!

[Anonymous · Accepted solution]

So close!  Take exactly what you put into that box, but instead of selecting "New Column", put the same formula into "New Measure".

[Rael]

Thanks Ross! I did the change and I got what I wanted. Attached the final result!

So, just one question: always that I need to do something like that I need to do a new measure, right? Because in my real case I need to put comparations with volume, net sales, price, and others things. So, possible I need to do one expression case by case, right? By the way, thanks one more time, and Have a good day!

[Anonymous]

Yep, Measures are the way to go. They are calculated at run time and even take into account all the current contexts.  Measures are why Power BI is so great!

[Rael]

Great!!! This is my first month using it, so I have a lot to learn.
Ross, do you know if is possible to put "total column" in the graph? I mean, my basic graph has Jan, Feb, and March, and I'd like to put a total (sum of that 3 months) to check the all.
Do you know if is possible?

[Anonymous]

There is a visual called 'Card' where you could place the same Measure into.  If you hide the title and leave just the numeric value, you could place that visual wherever you like, including on top of your graph.  This means you could either have a large tile overtly stating this sum total, or integrate it over your visual and make it seem like its part of it.

[Rael]

Hi Ross, thanks one more time! I tried the "card" and "gauge" and both look good. 

I just would like to try something like this:

It's the same information at Power BI (that I should you before) but here I put one more column "Total". I tried to do a some of all datas using CALENDARAUTO() to try me the sum of all things. With that I tried to put a total column but didn't work. So, do you know if exist something at BI to put an information like the picture?

Thanks one more time Ross, and Have a good weekend!!!

[Anonymous]

No, i'm not aware of any method presently that would allow you to place a Total Bar on the same graph.  Its an interesting idea, so perhaps its worth adding to the Ideas section.