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,
User | Count |
---|---|
82 | |
78 | |
67 | |
46 | |
45 |
User | Count |
---|---|
105 | |
44 | |
39 | |
39 | |
39 |