Forum Discussion

JCBI1023's avatar
JCBI1023
Helper III
8 years ago

Line and Clustered Column Chart - Line Value Help (With Pictures)

Hello!

 

I am comparing Fiscal Year GP %.  I created a Fiscal Year Calendar table that looks like this. And I am sorting all my month columns by "FiscalMonthNo". This allows me to compare last year's fiscal year month to this year's fiscal year month.

 

 

 

 

 

 

 

 

 

 

 

I also created and added two measured columns to this table:

1) FY2017 Service GP = CALCULATE(SUM('Service GP'[GP]),FILTER('Service GP','Service GP'[Fiscal Year] = "2017"))

2) FY2018 Service GP = CALCULATE(SUM('Service GP'[GP]),FILTER('Service GP','Service GP'[Fiscal Year] = "2018"))

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I want to plot the GP % as a line on this chart. Is that possible? Here's a look at my Service GP  % column:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

if I plot the GP % column as is, I get a "count of GP%:

 

 

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi JCBI1023,  

     

    I think your gp column stored text value, right? If this is a case, I'd like to suggest you convert them to numeric value first.

    Current chart not support text value, it will auto summary records by current group.(for text value, it will try to use count or other mode to summary them)

     

    Regards,
    Xiaoxin Sheng