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 people, I have a little issue trying to display some data, I hope you can help me with this.
The thing is I have a line chart with sales by period (nov-2018, dec-2018, jan-2019 and so on) but now I want to display only the last 12 periods based in date selections.
For example, if I pick in my year filter "2018" and in my month filter "October", the line chart should display sales from nov-2017 to oct-2018, and with no selections it should display sep-2018 to aug-2019 (as of today).
That's why a relative dates visual filter isn't of much help, because if I change years, the graph will not follow the applied filters.
That would be it. I hope I was able to explain myself as clearly as posible.
Solved! Go to Solution.
Hi,
You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hope this helps.
Hi,
You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hope this helps.
It works! Thanks!
But what's the logic behind having two Calendar tables in the data model?
You are welcome. One to show within the Pivot Table and the other to use in a slicer.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |