Make tooltips not filter by legends

[Pynter]

I have a bar chart with multiple bars and multiple legends, I want to make a rooltip which only filters by the x axis and not by the legends but I can't seem to do so, is there any way to do it? (I am using power bi desktop may 2022 and sadly cannot upgrade as of now)

[Daniel29195]

hello @Pynter 

create you own custom tooltip. 

https://www.youtube.com/watch?v=URTA7JZsAtw

and you need to use some DAX , to remove the filter coming from the legend 

example : 
calculate (  sum(table_name[col_name] ,  removefilters(table_name[legend_col_name]))

*---------------

If my response has successfully addressed your issue, kindly consider marking it as the accepted solution ✅. This not only helps you keep track of resolved matters but also assists other community members who may encounter similar challenges. Additionally, your acknowledgment by giving a thumbs up 👍 is greatly appreciated. Thank you for contributing to the community's collaborative spirit.

[Pynter]

Thanks doe the help @Daniel29195

This solves 50% of my problem as now the tooltip does not filter by the legends, however I now have the problem that all the legends are now the same %, so let's say my total count of rows is 60 and I got 3 legends, the pie graph I got in my legend is showing up as 33.33% 60, 33.33% 60, 33.33% 60 instead of something like 50% 30, 10% 6, 35% 24

[Daniel29195]

@Pynter 

is it possible to share the power file via link  so i can take a look ? 

[Pynter]

@Daniel29195 

I sadly cannot share the actual power bi file but I made a new file with the same error, please have a look at it
https://we.tl/t-CPNoJuzITI (WETRANSFER link)
Thanks 🙂

[Daniel29195 · Accepted solution]

@Pynter 

sorry for my late reply .

https://drive.google.com/file/d/113G4xjj5rWDFP2o_XSoCxrW4z0ogLjvA/view?usp=sharinghttps://drive.goog...

if this not what you want, can you please write on the screenshot the needed output numbers base on the sample data you have provided.

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍