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,
It is a new year, new data to load into your reports and new intressting Bi-statistics to look at.
Unfortunately, my time slicer has stoped to work. I cant se the year 2017 (but all the other years before). First I thought it was problem with the data (no data has income for year 2017, but it had, 975 post. Then I thought it was a date selection that didnt work correct (etc select date between xx and yy) but it was no error here either.
Then I tested to build the same report and used the new slicer from the lastest update (by new slicer i mean that i choose the slicer again, but this time with the new updated slicer from the latest release). Then It works, Both slicer use the same data but the older one, cant show later years - please se included picture.
Have any of you users who use power bi noticed the same thing?
Must I replace the slicer in each report? I have nearly 170 reports.
Best regards Per-Erik
Solved! Go to Solution.
Hi all,
I solved the problem. I had to "refresh" all slicers with time/date. I did this by choosing another controll and shifted back to same slicer. It seems like when Microsoft did there last update they forget to mention that timeslicers need to manually be updated.
So I did this in all my 170 reports and after the "refresh" all seems to work again.
Best regards
Hi all,
I solved the problem. I had to "refresh" all slicers with time/date. I did this by choosing another controll and shifted back to same slicer. It seems like when Microsoft did there last update they forget to mention that timeslicers need to manually be updated.
So I did this in all my 170 reports and after the "refresh" all seems to work again.
Best regards
My slicers work fine with the new year. One thing to look at, however, is to be sure you have 2017 in your date table. I generally only keep a few years in mine and had not added 2017 until today. A quick way to determine this would be to create a new page within the report and add a table. Drop only your year from the date table in and see if 2017 populates with the others. If it doesn't you may need to edit your query to include the new year in your date table.
Also, check your page and report level filters. If you missed clearing one, it may prevent the slicer from populating.
Proud to be a Super User!
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |