Forum Discussion
Report Tootip is not loading correctly
Hi All,
I create a report tooltip, and the figures are showing correctly. However, when I enable the report tooltip in the chart page the figures are blank.
Can you help me, please?
4 Replies
- edhans
Community Champion
We'd need to see more info , but I suggest you carefully read the documentation. Something isn't filtering properly and I suspect it is just a setting that article covers.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI ForumHi Edhans,
Thank you for your reply.
Here is the report tooltip page and the DAX Formulas:
Previous Week Bookings = CALCULATE([Total Billings], FILTER ('Calendar Lookup Table', 'Calendar Lookup Table'[Fiscal Week]= "FY21wk14") ) Current Week Bookings = CALCULATE([Total Billings], FILTER ('Calendar Lookup Table', 'Calendar Lookup Table'[Fiscal Week]= "FY21wk15") )Here the chart with the tooltip:- amitchandak
Super User
Anonymous , I doubt there WOW which has been put on the page and not visible here as there is a hardcoded week, the previous week may become 0. Add all of all selected.
Previous Week Bookings = CALCULATE([Total Billings], FILTER (all('Calendar Lookup Table'), 'Calendar Lookup Table'[Fiscal Week]= "FY21wk14") )in WOW, use divide function not just /.
divide([Current Week Bookings] -[Previous Week Bookings],[Previous Week Bookings])
You can refer to my blog How to deal with Week
