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.
I have a model as shown below
I created a visual below. I added filter Reporting Period for 12 months on the filter panel.
I want to create a 12 month rolling chart with a slicer month. I want the slicer MonthYear to filter the chart based on the monthyear selected back to 12 month rolling. For example, when I select Dec-22 on the slicer, then I want the visual to filter from Dec-22 to Nov-21 (12 months).
How can I achieve this?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi, @Anonymous,
try this:
https://drive.google.com/file/d/1Bpdg0PASnRxipLCItXPCMR7saq1Op0dG/view?usp=share_link
Hi,
Share the link from where i can download your PBI file.
Hi @Ashish_Mathur - here is the link to the pbix https://drive.google.com/file/d/1RoH7k5QsYCEsb1Qpy2IoBtj1BqEHECLI/view?usp=sharing
Access Denied message.
https://drive.google.com/file/d/1RoH7k5QsYCEsb1Qpy2IoBtj1BqEHECLI/view?usp=sharing
please can you check now
Hi,
You may download my PBI file from here.
Hope this helps.
Hi, @Anonymous,
You need a separate, unconnected date table. Remove the relative filtering on your measure.
Write a measure like this:
Measure1 =
VAR _date_unconnected =
CALCULATE ( SELECTEDVALUE ( 'Dates unnconnected'[month] ) )
VAR _date =
CALCULATE ( SELECTEDVALUE ( Dates[Month] ) )
RETURN
IF (
ISBLANK ( _date_unconnected ),
SUM ( sales[sales] ),
CALCULATE (
SUM ( sales[sales] ),
FILTER (
ALL ( Dates ),
_date >= ( _date_unconnected - 365 )
&& _date <= _date_unconnected
&& Dates[Month] = _date
)
)
)
where month is the first day of every month.
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
User | Count |
---|---|
84 | |
80 | |
69 | |
46 | |
46 |
User | Count |
---|---|
106 | |
45 | |
42 | |
39 | |
39 |