Hi,
This one is around tool tips. When I hover my mouse on this year sales, I get the desired result filtering the products, but this doesn’t work when I move to SPYA (same period last year) column, it doesn’t show me last years products. Is there a fix for this or this is the default behavior. To see last year products I have to use the slicer and change it to 2023 and then hover my mouse over total sales.
Any ideas on how to get around…
Hi @chris786 ,
Thank you for reaching out to the community.
While we wait for other members to share their insights, we’ve taken the liberty of using “Explain Simply ,” one of the tools available within Data Mentor.
Feel free to checkout more of our Data Mentor features as you work on your report. These tools are designed to help with tasks like the one you’re working on, and they might accelerate your learning curve.
Cheers,
Enterprise DNA Support Team
Hi @chris786 - Please share sample PBIX file to check.
Thanks
Ankit J
HI Ankit,
Please find attached, it is on the Dashboard sheet.
Thank you.
Sales 2024 BI - Copy.pbix (8.2 MB)
The items shown in the tooltip page are fixed as [Item Short Name], [Total Qty], [Total Sales], and [Avg Price] for the selected customer account. you have to create a different table and show the sales for last year.
Hi,
I’m using field parameters, could be that is why the sales for last year don’t show up in tool tips. For me I find it better to filter the slicer by last year and then see the tool tips in total sales.
But the tool tips should work automatically and filter for both current year and last year. Don’t know if anyone has faced the same kind of issue.