cancel
Showing results for
Did you mean:
Member

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

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

6 REPLIES 6
Super User

## Re: MoM% Measure Showing 0.00%

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...

Proud to be a Datanaut!

Member

## Re: MoM% Measure Showing 0.00%

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

Super User

## Re: MoM% Measure Showing 0.00%

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)```

Proud to be a Datanaut!

Community Support Team

## Re: MoM% Measure Showing 0.00%

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: MoM% Measure Showing 0.00%

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

Highlighted
Community Support Team

## Re: MoM% Measure Showing 0.00%

hi, @atul9063

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

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.