Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to combine sales and target chart into 1 ?

Hi All

I have 2 seperate chart :-

Paulyeo11_0-1606657395394.png

 

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

Paulyeo11_1-1606657554037.png

 

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

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

aj1973_0-1606692057527.png

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

aj1973_1-1606692162214.png

 

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

 

 

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

10 REPLIES 10
ryan_mayu
Super User
Super User

@Paulyeo11 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Paulyeo11
Impactful Individual
Impactful Individual

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?...

 

Paulyeo11_0-1606690193411.png

 

aj1973
Community Champion
Community Champion

Use the Hierarchie level in your visual

aj1973_0-1606658194839.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Paulyeo11
Impactful Individual
Impactful Individual

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
Community Champion
Community Champion

Is this what you are looking for?

aj1973_0-1606691322104.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Paulyeo11
Impactful Individual
Impactful Individual

Hi AJ

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

aj1973
Community Champion
Community Champion

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

aj1973_0-1606692057527.png

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

aj1973_1-1606692162214.png

 

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

 

 

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Paulyeo11
Impactful Individual
Impactful Individual

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

Paulyeo11_1-1606693404275.png

 

Paulyeo11
Impactful Individual
Impactful Individual

Hi sir

it work now.

thank you very much.

Paulyeo11_0-1606693219019.png

 

aj1973
Community Champion
Community Champion

You are welcome 

Mark it as a solution please for the community 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.