Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi.
I have a calendar table in my model and want that when I select a period in the slicer, it detects the previous 13 months and in the line chart shows me only those months, in this moment I have to select on the slicer the 13 months that I want to see.
Thanks
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
"when I select a period in the slicer" - how do yo then decide what "previous 13 months" should be? From the beginning of the period? from the end? or the full last 13 months before your slicer period?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |