Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have created a power BI report that cummulates historical data to show how many people have been trained in a certain topic up to this point in time. I only want to display the last year in a filter, but when I apply either a relative date slicer or do a year offset on the entire page, I lose all the data that was added before that date of viewing.
My goal is to simply change the viewing range to one year without excluding that historical data, as it changes the cummulative values for the current month.
Hi @Anonymous ,
According to your needs, you can try the "Edit interaction" function in the Format window of the desktop.Customize the visual object that generates the interaction.
The solution provided here should help you solve the problem:Solved: Re: Dax expression to create static content on car... - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You can remove the filter using interactions.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Or you can take complete range and use Time intelligence (with date table)
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
54 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |