topic Re: Custom tooltip measure that filters in DAX Commands and Tips

Custom tooltip measure that filters

Dave1234 — Sat, 14 Sep 2024 08:26:23 GMT

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

Re: Custom tooltip measure that filters

Sahir_Maharaj — Sat, 14 Sep 2024 21:05:36 GMT

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 )

Re: Custom tooltip measure that filters

Dave1234 — Sun, 15 Sep 2024 11:21:35 GMT

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

Re: Custom tooltip measure that filters

Dave1234 — Sun, 15 Sep 2024 13:26:08 GMT

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

Re: Custom tooltip measure that filters

Anonymous — Fri, 20 Sep 2024 05:33:35 GMT

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.