Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Im using directquery and I want a column chart that always shows the last 12 months.
I tryied to use something with DATEDIFF, MAX(DATE),... But with no success.
I have two tables, one is my Date table and the other with my data. And they are joined with date column.
I was looking for something similar -- a chart that showed the last 12 months of data (NOT necessarily 12 months from today). First, I created a measure that finds all the distinct dates:
One way you could filter the data in the visual to the last 12 months..
1. Click the bar chart visual
2. In the Visualizations pane, under Filters click the date field
3. Change the Filter Type to Relative date filtering
4. Change to "is in the last 12 months" as shown in screenshot below
💗this solution.
Thank you for this info. Is there a way to move January 2023 column AFTER December 2022?
You may need extra columns in your Date Table for the sorting.
Make a "Month sorting order", then English Month Column sorted by that Column.
I copied the code form some youtube video.
@JayHerrera its not work for me.
Its fixed to that range of dates. I want something more dynamic like, filter a Month and its return the last 12 months of that filtered month.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
72 | |
49 |
User | Count |
---|---|
142 | |
137 | |
110 | |
69 | |
55 |