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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
67 | |
64 | |
57 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |