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.
Solved! Go to Solution.
Hi @Anonymous ,
Do you mean to show current date range and the previous 3 years date on the axis?
You could create a new column to show the data 3 years ago with DATEADD() function. Then create a date dimension as slicer and use measure to show the result with 1 or 0. Now you could set rule in the filter pane.
Here is my test file for your reference.
Hi @Anonymous ,
Do you mean to show current date range and the previous 3 years date on the axis?
You could create a new column to show the data 3 years ago with DATEADD() function. Then create a date dimension as slicer and use measure to show the result with 1 or 0. Now you could set rule in the filter pane.
Here is my test file for your reference.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |