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.
I've just noticed this issue, not sure how long it has been present:
When I select a range (including today), other than the entire range of dates, data for today is included in the output.
But when the slicer includes the entire range then today's data is excluded:
Initially I thought maybe there is too much data for the slicer to deal with (it's only 12k rows) but I removed all rows except the current month (down to 191 rows) but the problem still exists.
I don't understand why this is happening but maybe I've configured my project incorrectly. I have a Calendar table and have created a date column in my data table to link my calendar table to.
I've put a copy of my sample data here, it'll only be available for 30 days from this post however. Note the names are randomly generated.
Version: 2.49.4831.521 64-bit (August 2017)
Solved! Go to Solution.
Should be working now, please verify it.
Best Regards,
Herbert
All visual packages are loaded from CDN directly, even if you import package manually.
It means that your Desktop app uses the latest version of the visual, even if Office Store displays the previous one.
Best Regards,
Herbert
Hi @KarlinOz,
As I tried today, it works fine. Could you please check it out?
If this issue is fixed, please mark the proper answers as solution.
Best Regards!
Dale
Click on your timeline slicer visual. In the menu in the ribbon select the "Format" tab. Toggle on the 'Edit Interactions'. What icons do you now see in the other visuals? If the circle with the line through it is selected, thats the problem.
If thats not the problem, check your arrows in the Table Relationships. Change them from Single to Both. You do this by double clicking on the table relationship lines and updating the value in the window that appears. It should be under 'Cross Filter Direction'
Hi @Anonymous,
Thanks for your suggestions.
I definitely have the interaction with the slicer turned on:
And switching the cross filter direction to 'both' has no effect.
Hi @KarlinOz,
As I tested, it did go wrong. I am going to submit an report internally. I will post here if I get any updates.
Best Regards!
Dale
ETA for publishing new version of the visual is Aug, 30. Please check it later.
Best Regards,
Herbert
Great news, thanks for the feedback Herbert @v-haibl-msft I'll give it a go as soon as it's available.
Still waiting on the visual to be updated in the store, the current version there is still showing 21 March.
Hi Herbert @v-haibl-msft, yes I can confirm it is now working. So how is that possible? I didn't update Power BI Desktop nor re-download the visual, in fact the visual in the store still shows the date of 21 March 2017. Does Power BI automatically look for updated visuals on start-up? or was there an issue just with August data and now it is September all is showing ok?
All visual packages are loaded from CDN directly, even if you import package manually.
It means that your Desktop app uses the latest version of the visual, even if Office Store displays the previous one.
Best Regards,
Herbert
Great, thanks for that info Herbert @v-haibl-msft.
And I have just noticed that it is fixed in the Desktop model but the Service still has the issue - I guess the visual in the service has not been updated yet.
Hi @KarlinOz,
As I tried today, it works fine. Could you please check it out?
If this issue is fixed, please mark the proper answers as solution.
Best Regards!
Dale
Hi @v-jiascu-msft Dale, thanks I just tried it now and it is working in the service now as well.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |