Custom tooltip please help

[Dave1234]

Can anyone help i have a table with activity, periods, values these are %.

Summary page has a doughnut chart which is filtered on the visual for a specific catergory, the page is filtered to the latest period.

I want a tooltip that when hover over the doughnut chart it will show a bar chart with each period for that activity only

I have tried to write a measure to ignore the period filter but keep catergory but wont work any help be appreciated

There will be multiple doughnut charts

[Anonymous]

Hi @Dave1234 ,

Could you please show more details? Such as pbix file as tharunkumarRTK mentioned.

If you only want to keep filtering on catergory, I recommend using the ALLEXCEPT function.

ALLEXCEPT function (DAX) - DAX | Microsoft Learn

According to your description, do you want to set a bar chart as tooltip?

I recommedn you set a blank page to tooltip page and modify canvans size to tooltip. Then add the bar chart.

At last, add the page as tooltip in doughnut chart.

Best regards,

Mengmeng Li

[tharunkumarRTK]

@Dave1234 

can you share the pbix file?