Historical line chart

[Tycobb479]

Hello dear collaborators!
I'd like to kindly ask for your help regarding the following: I have the below information and I would like to calculate the subtotals for A and B and then divide [(subtotal A) / (subtotal B)] to get the values per month (the highlighted table), as my aim is to plot these monthly values in a line chart to visualize the trend. The first criteria will be to filter the info out by date (month), but I also have some codes associated to more slicers. I have tried to work this out with no success (I'm quite new using PowerBi). Is there anyone that can guide me to solve this problem? Thanks in advance!

[dcrow5378 · Accepted solution]

You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:

[MahyarTF · Accepted solution]

Hi,

You could create the Month-Num column in your table as below :

Month-Num = format(Sheet81[Date], "MM")

And also 

Value = DIVIDE( sum(Sheet81[A]), sum(Sheet81[B] ))

then use the created column in your visuals :

[Tycobb479]

Thank you for your alternative solution, MahyarTF! Much appreciatted!

[dcrow5378 · Accepted solution]

You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:

[Tycobb479]

Thank you for your fast reply, dcrow5378!