The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I'm facing a strange issue...
When I add measure into Tooltip fields it shows correct data however when I add the same measure with no other filters on a Custom Page Tooltip and change Tooltip options from Auto to Custom Page the data is wrong...
Below you can find a measure:
Below how the custom page tooltip works (changing based on step you hover over) - wrong behaviour:
And here how it works with auto tooltip (not changing no matter which step you hover over) - proper behaviour:
How is it possible that the same measure shows different values based on whether it was added into tooltip fields or tooltip custom page?
The issue occured due to different date ranges being used for specific step therefore once I've added a slicer from Calendar table to filter the outcome it started to work properly with custom report page.
Not sure why the date range didn't interact with the automatic tooltip but I guess we can close this topic unless somebody know why automatic tooltip doesn't interact with a date range while custom report page does...
Example:
Step, Date, Ratio
Translation, 21.07.2023, 0.5
Translation, 23.07.2023, 0.2
Review 1, 23.07.2023, 0.15
Review 2, 23.07.2023, 0.2
While looking at the automatic tooltip it would show (0.5+0.2)/2+0.15+0.2 on every step
However when using custom report page tooltip it would show the same outcome only for Translation step but when you hover over Reviews it would show only the ratios from the same date range so 0.2+0.15+0.2.
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.