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

[JCBI1023]

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%:

[v-shex-msft]

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