Yearly Trend of Data Dynamically

[J_Tanna]

Hi,

I am making a report in powerBI and came up with different requirement. I am displaying one bar chart to showcase yearly trend of data but I am unable to display it dynamically. So when I select month it should show data till that month only. I am using financial year.

Like, 

When I select month May data sholud be for April, May

For June data should be for April, May, June. 

Kindly help me with this issue. It will be a big help for me.

Let me know if you have some doubts in question.

Thank You.

[v-yulgu-msft · Accepted solution]

Hi @J_Tanna,

You need a calendar table which is not related to source table, add a Month column from calendar table into slicer. To get the selected month and filter monthly data depend on this selected month, you could use a filter expression like below inside the measure which calculates results dispalyed on chart Y-axis.

FILTER(Source_data,Source_data[Month]<=MAX(Dim[Month])

For more details, please refer to the uploaded .pbix file.

Best regards,

Yuliana Gu

[rajulshah]

Hello ,

You can use TOTALYTD dax function.

Please refer here : https://msdn.microsoft.com/en-us/library/ee634400.aspx

It also can be used for different financial years.

[J_Tanna]

Hi Rajul,

Thank You for your response.

I want to showcase data for each month separatly. Can you help me on this?