Custom tooltip measure that filters

[Dave1234]

I have a doughnut chart that is filtered for one catergory which is heating and the lage filter is set to just a single period p5

I want to create a measure that i can use as a tooltip that will still filter the catergory so it only shows the one im hovering over but will show all periods for that catergory 

Can anyone help please 

[Sahir_Maharaj]

Hello @Dave1234,

Can you please try this approach:

Tooltip Measure = 
VAR SelectedCategory = SELECTEDVALUE('YourTable'[Category])
RETURN
CALCULATE(
    SUM('YourTable'[Value]),  -- Or whatever measure you're summing up
    'YourTable'[Category] = SelectedCategory,
    ALL('YourTable'[Period])  -- This removes the filter on the Period
)

[Dave1234]

Its only showing P5 for that catergory ic want it to show all the periods in the bar chart for that catergory, thank you

[Anonymous]

Hi All,
Firstly Sahir_Maharaj thank you for your solution!
And @Dave1234 ,you want to click on P5 to display the entire bar chart, unfortunately due to the limitations of the Power BI environment this is not easy to do, after we select P5, the entire pie chart will also be changed, the pie chart will only select the value of P5, so in this case, the filtering is mandatory, we can not ignore it.

Measure = CALCULATE(SUM('heating_cooling_sales'[Sales]),ALLSELECTED('heating_cooling_sales'[Category]))

We also tried the following, which is to not keep all the filters, this seems to allow you to show all the values when selecting P5, but there is still a problem, which means that he can't separate the different sales by category, it will only be one type of sales.

Again, I apologize that the limitations of the pie chart may not be perfect for your needs, if you have further thoughts or ideas, feel free to contact me and I will get back to you as soon as I receive the message!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Dave1234]

Thank you i am going to try this, should this show all the periods seperate  so like a bar chart for p1, p2, p3 etc when i hover over the doughnut chart, thank you