Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
For some reason, the tooltip that shows data points when hovering across a line chart, simply does not show for the last day of the month. Everything works fine, the data is correct, legends etc. work fine. It's just this one thing I can't get to work. I get data for the second to last day, but not the last. I have tried to expand padding to the right of the chart but that made no difference. Any ideas, anyone?
Solved! Go to Solution.
Found it!!! Thank you for pointing me towards a fresh canvas (creating the support pbix). It turns out that the limitations I had set on the x-axis range caused the problem. From a time when I struggled with other issues, I had set Minimum as f(x) Earliest Date and Maximum as f(x) Latest Date. Once I removed those restrictions, it all worked as expected. I don't understand why the conditional formatting on the axis did not work, but I'm happy to have solved it. Once again, thank you.
The data is visible when showing as table. I will try your suggestion, but find it odd that that would be necessary. I was hoping this was a known issue with a clever solution :-).
Hi @Cadenze
If you click on the ... in the top right and choose "Show as table" do the rows of data appear in there?
I appreciate this is a nuclear option but have you tried using a Report Page tooltip:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
I tried the report page as a tooltip, and this one does also not show the data for the last day. Any other ideas?
Hmm I cannot recreate the issue.
Could you try with some dummy data and see if the issue persists.
If it does provide the pbix with the dummy data please.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Found it!!! Thank you for pointing me towards a fresh canvas (creating the support pbix). It turns out that the limitations I had set on the x-axis range caused the problem. From a time when I struggled with other issues, I had set Minimum as f(x) Earliest Date and Maximum as f(x) Latest Date. Once I removed those restrictions, it all worked as expected. I don't understand why the conditional formatting on the axis did not work, but I'm happy to have solved it. Once again, thank you.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
55 | |
37 | |
31 |
User | Count |
---|---|
83 | |
64 | |
63 | |
49 | |
45 |