The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |