Line Chart Showing Negative Axis

[Anonymous]

Hello Guys,

Need some help , so i have a quarter on quarter chart for a metric.
The problem is whenever i am selecting any slicer the chart shows 0 values because it doesnt has any value and also shows a negative Y axis.
Also the metric i have is this :

Previous Year Won Job Fee = 
var PrevYear = LEFT(MaxYear,4)-1 & "-" & RIGHT(MaxYear,4)-1
var year = [Prev YTD]
return
IF((CALCULATE(SUM('Pipeline Master'[Job Fee]), FILTER('Pipeline Master','Pipeline Master'[Status (groups)]="Won" && 'Pipeline Master'[Won FY] =year && 'Pipeline Master'[Is CGP] = "Yes"))/100000)=0,0,

//If not 0

CALCULATE(SUM('Pipeline Master'[Job Fee]), FILTER('Pipeline Master','Pipeline Master'[Status (groups)]="Won" &&'Pipeline Master'[Won FY]=year && 'Pipeline Master'[Is CGP] = "Yes"))/100000)

the "year" returns me "2019-2020".
Please let me know what i can do to resolve the negative axis and the 0s that are showing up. 

[v-yuta-msft]

@Anonymous ,

It seems that condition "'Pipeline Master'[Won FY] = year" can't be met in your measure. In addtion, if you could share some sample data and give the expression of [MaxYear] I could do further analysis.

You can set the start point from 0 to remove the negative Y-axis.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msftThanks for your reply.
I forgot to mention that only "year" is used the MaxYear and PrevYear are not used in this.The prevYTD gives me "2019-2020" kind of format .Also attaching the sample data.Please help.

Name

Pipeline Description

Nrcc Status

Billing Currency

Final Proposed Fee

Final Proposed Ope

Expected Recovery %

Won Expected Recovery %

Contact Name

Contact Location

Client Group Name

Client Name

Expertise

Revenue

Location

Lead Generator

Lead Converter1

Lead Converter2

CSL

EBUL/SMEGL

RML

Expected Fee

Win Probability

Won Reason

Won Reason Description

Job Id

Created User Name

Created User Location

Creation Date

Status

Pending With

Relationship Office

Client City

Client Contact City

Client Contact State

Client Creation Date

Won Actual Pipeline Close Date

Pipeline Code

Job Fee

PRIMARY INDUSTRY

PRIMARY SUB INDUSTRY

Secondary Industry

Secondary Subindustry

Tertiary Industry

Tertiary Subindustry

Pipeline Lost Date

Lost Reason

Contact Relationship Office

RSML

Client Startup

Client Type

Recurring/Non-Recurring

Sector

How Was the lead generated

IRC Status

NatureOfBussiness

Territory

Email ID

Job Created

Fiscal Year

Creation Date Month

Status (groups)

MTBU/BU

Creation_FY Month

Rec/Non-Rec

JOB Code

FY_Period

Won Fiscal Month

Won Fiscal Month No.

Lost Fiscal Month

Lost Fiscal Month No.

Won FY

Is CGP

Lost FY

SME Group.1

SME Group.2

Expected Recovery_%

Won FY Period

Lost FY Period

Project Code

Lost This Year

Won This Year

WonFiscalQrt

LostFiscalQrt

MaxCreationFiscalYear

LiveFiscalQrt

TYPipeline

LostDatePeriod

LiveDatePeriod

Created This Year

Previous Year

GRO-Tech-West-XYZ LIMITED.-1920-2

Internal Audit

70

Mr. JHK

MUMBAI

ABC

Abc Telco

Risk

Mumbai Parel

₹5,200,000

Medium

Mumbai Parel

21 February 2020

Approved

Mumbai

Hyderabad

MUMBAI

Maharashtra

2/6/2019 12:38:11 PM

41529

Mumbai Parel

No

New Client

Recurring

Financial Services

past relationship

NA

Organic

West

No

2019-2020

February

Live

TECH-West

11

Period 2

Yes

GRO

Tech-West

70.00%

0

0

FQ4

FQ4

0

FQ4

No

Older than 6 Months

Last 6 Months

0

1

GRO-Tech-West-ABC Limited-1920-2

Internal Audit

70

Mr. JHJ

MUMBAI

ABC

ABC Finance

Risk

Mumbai Parel

₹1,800,000

Medium

Mumbai Parel

24 February 2020

Approved

Mumbai

Mumbai

MUMBAI

Maharashtra

2/6/2019 12:38:11 PM

41550

Mumbai Parel

No

New Client

Recurring

Financial Services

past relationship

NA

Organic

West

No

2019-2020

February

Live

TECH-West

11

Period 2

Yes

GRO

Tech-West

70.00%

0

0

FQ4

FQ4

0

FQ4

No

Older than 6 Months

Last 6 Months

0

1

[v-yuta-msft · Accepted solution]

@Anonymous ,

Is there any data in column [Won FY]?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msftYes it does.The sample that i shared doesnt .You can put values as "2019-2020" or same fomat.

[nandukrishnavs]

@Anonymous 

You could fix the Y axis start position as 0. Then it will not show any negative axis.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂