Forum Discussion
Calculate Tooltips
Hi,
Assuming you have a fact table with columns/measures: Live, Question, and E-mail and each presumably a count per row, and a Date dimension table related to fact table.
I think your Measures on Y-axis are already something like:
Live = SUM('table'[Live])then your monthly total would be
Monthly Total = [Live] + [Question] + [E-mail]and your Percent would be
Live % = DIVIDE([Live], [Monthly Total]) Question % = DIVIDE([Question], [Monthly Total]) Email % = DIVIDE([E-mail], [Monthly Total])For the tooltip, you may use ToolTip page instead of default tooltip. You can place either a matrix visual or Multi-card visual on the tooltip page. On my demo file it will show as below
In case you need more about tooltip page you can refer to
Create report tooltip pages in Power BI - Power BI | Microsoft Learn
Hope this answered your question:)
Hi e175429
So if you just drag the fields from table, that would be Implicit measures generated by Power BI itself. In this case i'd suggest using Explicit measures like
Live = SUM('table'[Live])to aggregate your data properly and follow the rest of my calculation approaches in the last message.
For the differences between these two different measures you may find more from Radacad below.
Explicit Vs Implicit DAX Measures in Power BI - RADACAD
Hope this helps:)
