Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
107 | |
56 | |
52 | |
48 | |
40 |