Forum Discussion
Historical line chart
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!
You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:
Hi,
You could create the Month-Num column in your table as below :
Month-Num = format(Sheet81[Date], "MM")And alsoValue = DIVIDE( sum(Sheet81[A]), sum(Sheet81[B] ))then use the created column in your visuals :
4 Replies
- dcrow5378
Resolver I
You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:
Thank you for your fast reply, dcrow5378!
MahyarTFMemorable Member
Hi,
You could create the Month-Num column in your table as below :
Month-Num = format(Sheet81[Date], "MM")And alsoValue = DIVIDE( sum(Sheet81[A]), sum(Sheet81[B] ))then use the created column in your visuals :Thank you for your alternative solution, MahyarTF! Much appreciatted!
