How to combine sales and target chart into 1 ?

[Anonymous]

Hi All

I have 2 seperate chart :-

I get below when i using cluster bar chart , below chart target amount after plot is wrong :-

[ryan_mayu]

@Anonymous 

Is the Group field from Dimension table or from sales or target table? maybe you can try use the group field from dimension table.

[Anonymous]

Hi Ryan

Thank you for your sharing . what you said seen you know how to solve my issue. i try still unable to get it right.

Below is my PBI file.

https://www.dropbox.com/s/bzopufbqn1ypwmz/PB_TDS_V080%20sales%20vs%20target%20in%20one%20chart.pbix?...

[aj1973]

Use the Hierarchie level in your visual

[Anonymous]

Hi Aj

yes , it work , but i like to make use of chart to show :-

X axis = GROUP

Y axis = Sales Amt ( Green Bar )

Y axis = Target Amt ( Red Dot )

[aj1973]

Is this what you are looking for?

[Anonymous]

Hi AJ

Yes that is what I need. Can you share how you do it? May be can share the PBI File.

[aj1973 · Accepted solution]

It's your PBIX file not mine,

Copy Paste the table

Change it to Line and Column stacked Chart

Add the Merasure Target_ to the Line values of the visual. That's it

to see the line style dotted go Format and Shapes, choose your prefered style

Nice ain't it!

Remarque: you can use the field TARGET_AMT  as well, there was no need to create a new measure TARGET_ for the Sum. Power BI takes care of that directly in the visual

[Anonymous]

HI aj

Regarding rename the :- 

TARGET_AMT

Because i need to create expression for below , So i need to make the TARGET become measure , i just try , and it does not able to work if i dont convert it to measure :-

Target YTD =

var _max = today()

return

calculate(TOTALYTD(('TARGET'[TARGET_]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

[Anonymous]

Hi sir

it work now.

thank you very much.

[aj1973]

You are welcome 

Mark it as a solution please for the community