Show sales overview for sales entities in line chart

[IrfanMukhtiar]

Hi everyone, 

I am begineer in Power BI, So please bear with me. 

I am working on to show sales OOB entities "Months(getting from 'created-on') and statecode into line chart". 
I need to show different reprsentation for different entities in one line chart. Please see below image for better and clear understanding. 

I am able to make seperate tables for sales entities and showing GUI as in upper image but not able to collect all sales data into one "Line chart". 

Any of your help will be greatly appreciated. 

Best Regards, 
Irfan Mukhtar

[KT_Bsmart2gethe]

Hi @IrfanMukhtiar 

May I clarify a few questions?

• What do you mean by not being able to get all the data into the chart? Statecode?
• Are you referring to a visual challenge or table relationship challenge?

I'm trying to understand where your challenges are to assist you from there.

Regards

KT

[IrfanMukhtiar]

Hi, 

My issue is, I need to show "All 'sales entities' (Leads, opportunities, quotes and order seperate visual reprsentation in one line chart)". 

I need to show 
"How many leads are disqualiied"?
"How many opportunites won"
"How many quotes won"
"How many order are in-progress or complete". 

Please open & see my attached image for clear understanding. 

[KT_Bsmart2gethe]

Hi @IrfanMukhtiar ,

I understand that you need to show All sales entities, and I looked at the attached image.

Let's go back to the starting point. Is the attached image your desired outcome?

I see four lines in the chart: leads, opportunities, quotes and order count. If it is your desired outcome and where are we now?

I am trying to help, but without knowing where is challenge comes from (i.e. the data structure, current state, future state, etc.), I can only ask you some questions to assist you in achieving the outcome.

Regards

KT