Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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.
Hi Rajul,
Thank You for your response.
I want to showcase data for each month separatly. Can you help me on this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |