Not able to add Product Category Name in legend field in Line Chart

[atul9063]

Hi,

I want to display Total Profit and Total Revenue both in Line chart for ProductCategory Name as legend. But i m not able to add it chart ProductCategory name in legend field.

Thanks

[v-lili6-msft]

hi, @atul9063

There is nothing wrong with your formula. since you need to calculate MoM%, you need to drag the field 'Calender'[Date]

from Calender table into visual, this will calculate with Time Intelligence.

Best Regards,

Lin

[atul9063]

ame tI have done thing but its not working.Anyway now im calculating in SQL

[v-lili6-msft]

hi, @atul9063

You could just drag the field 'Calender'[Date] into Columns value of Matrix like below:

Best Regards,

Lin

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[atul9063]

@Greg_DecklerCan you share MoM% change formula in DAX without using time intellugence function?

[Greg_Deckler]

Should be something along the lines of:

TITHW_%ChangeYoY = 
VAR __MaxYear = MAX('Years'[Year])
VAR __MaxMonth = MAX('Months'[MonthSort])
VAR __TmpTable = CALCULATETABLE('TheHardWay','Years'[Year]=__MaxYear,All('Months'[Month]))
VAR __currentMonth = SUMX(FILTER(__TmpTable,[MonthSort] = __MaxMonth),[Value])
VAR __previousMonth = SUMX(FILTER(__TmpTable,[[MonthSort] = __MaxMonth - 1),[Value])
RETURN DIVIDE(__currentMonth - __previousMonth,__previousMonth,0)