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 all,
i have a slicer YEAR with to much years from 1990 - 2029. i want to limit it to 2017-2019 (year of today and the last 3 years).
the problem is that i work in a live connection with a tabular model. i cant write columns. only measures. and measures are not accepted in slicers.
many thanks!
Solved! Go to Solution.
Hi,
I assume that you should be having a Date Column. This Date Column should be connected to another Table which would have the Continuous set of Date Values. When you are seeing this column inside of Power BI, you should be seeing the Year in the Hierarchy. Add this to the Slicer.
Now to limit it to the last 3 years, Take the Date Column in the Dim_Date (Diemension Table) and add the same to the Reports' Page Level Filter. Now Select Relative Filtering Option and You can input Anything like 36 and Months.
Best Regards,
Vignesh M
If what I suggested worked for you, feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
Hi,
I assume that you should be having a Date Column. This Date Column should be connected to another Table which would have the Continuous set of Date Values. When you are seeing this column inside of Power BI, you should be seeing the Year in the Hierarchy. Add this to the Slicer.
Now to limit it to the last 3 years, Take the Date Column in the Dim_Date (Diemension Table) and add the same to the Reports' Page Level Filter. Now Select Relative Filtering Option and You can input Anything like 36 and Months.
Best Regards,
Vignesh M
If what I suggested worked for you, feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |