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 s...
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.
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.
v-yuta-msftYes it does.The sample that i shared doesnt .You can put values as "2019-2020" or same fomat.