Forum Discussion
Clustered column chart - make tooltip use filters?
Hi,
I have a clustered column chart. Here I want to display a percentage of tasks completed within a time frame as a YTD and Previous month. It looks like the below. The percentage is calculated from either a 1 (=the task is completed within the timeframe) or a 0 (=the task is completed outside the designated timeframe)
I have the "task" column as a tooltip. However it shows both with the entire amount of tasks for the year. Why?
My measures looks like the below.
Hi Irwin
The option "keep all filters" refers to drill-through functionality and not to tooltips.According to your request, the measures that you put on the graph don't give filter context to the tooltip.
To assist more I need a data to work with soPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
3 Replies
- Ritaf1983
Super User
Hi Irwin
The option "keep all filters" refers to drill-through functionality and not to tooltips.According to your request, the measures that you put on the graph don't give filter context to the tooltip.
To assist more I need a data to work with soPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- Irwin
Helper IV
Thank you for your reply. Much appreciated.
Unfortunately the data is confidential. Could you perhaps instead guide me in the direction of some training material that explains more about filter context for tool tips?- Ritaf1983
Super User
I need to understand what you trying to do 🙂
You can prepare some dummy pbix just to show the needed logic.