Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Irwin
Helper IV
Helper IV

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)

Irwin_0-1702373263674.png

Irwin_1-1702373280675.png

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.

 

YTD =
VAR OnTime = COUNTROWS(FILTER('TaskTable', 'TaskTable'[IS_OK]=1))
VAR Blanks = COUNTBLANK('TaskTable'[IS_OK])
VAR OffTime = CALCULATE(COUNTROWS(FILTER('TaskTable', 'TaskTable'[IS_OK]=0))-Blanks)

Return
DIVIDE(
        OnTime, OffTime+OnTime)+0
 
 
This Month =
CALCULATE(
    [YTD],
    DATESMTD(Calendar[CalendarKey])
)
 
 
Previous Month =
IF(    
    CALCULATE(    
        [This Month],    
        DATEADD(Calendar[CalendarKey], -1, Month)    
    ) = 0,    
    0,    
    CALCULATE(    
        [This Month],    
        DATEADD(Calendar[CalendarKey], -1, Month)    
    ) + 0    
)    
 
It makes no change whether I togle "keep all filters" on or off
Irwin_2-1702373749667.png

 

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @Irwin 
The option "keep all filters" refers to drill-through functionality and not to tooltips.

Ritaf1983_0-1702533441799.png

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 so 

Please 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

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? 

 

I need to understand what you trying to do 🙂

You can prepare some dummy pbix just to show the needed logic.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.