Forum Discussion
Line Chart Showing Negative Axis
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.
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.
5 Replies
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 🙂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.
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 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.
