Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
All,
I am showing a running total of counts for the past 2 years. The chart is getting too wide for my customer. I need to keep the totals based on the entire time period. But I would like to only show the last 12 months. The X-axis has a Start and End Date but I don't see a way to make it dynamic based on my live data. I could hard code the dates but then I would have to change it manually each month as I am in the screen shot below.
Any ideas? Or different charts I should use?
I am using the latest PBIRS (on premises).
Thanks in advance, Scott
Solved! Go to Solution.
Hi @wskallmeyer
You may create a measure like below and use it in visual level filter and set it =1.
Last 12 Month = VAR EndThisMonth = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 31 ) VAR Enddate_LastMonth = EDATE ( EndThisMonth, -1 ) RETURN IF ( MAX ( 'Date'[Date] ) <= Enddate_LastMonth && MAX ( 'Date'[Date] ) > EDATE ( EndThisMonth, -13 ), 1 )
Regards,
Hi @wskallmeyer
You may create a measure like below and use it in visual level filter and set it =1.
Last 12 Month = VAR EndThisMonth = DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 31 ) VAR Enddate_LastMonth = EDATE ( EndThisMonth, -1 ) RETURN IF ( MAX ( 'Date'[Date] ) <= Enddate_LastMonth && MAX ( 'Date'[Date] ) > EDATE ( EndThisMonth, -13 ), 1 )
Regards,
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |