Forum Discussion
Solved
ToolTip Advance - Filter Help
Hi all, I'm working on a Power BI report where I show monthly Gross Sales in a table and would like to display a tooltip chart when hovering over the table rows. The goal of this tooltip is to show ...
Hi dvraan
You would need to create a seperate table with the Month Name in it and use that in a slicer.
This would not filter the model.
Instead we edit the Gross column to say:
Gross = CALCULATE( SUM(Sales[Gross Sales]), 'Date'[Month] = SELECTEDVALUE('Month Table'[Month name]))Then in the tooltip chart just put the:
SUM(Sales[Gross Sales])
Hi dvraan
You would need to create a seperate table with the Month Name in it and use that in a slicer.
This would not filter the model.
Instead we edit the Gross column to say:
Gross = CALCULATE( SUM(Sales[Gross Sales]), 'Date'[Month] = SELECTEDVALUE('Month Table'[Month name]))
Then in the tooltip chart just put the:
SUM(Sales[Gross Sales])
SUM(Sales[Gross Sales])