Forum Discussion
e175429
1 year agoHelper IV
Calculate Tooltips
Hello all, This is a sample of my data (I would love to upload the BI file but only certain users can do that): Date Live Question Email 1/2023 2774 249 431 2/2023 2683 156 2...
- 1 year ago
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:)