Forum Discussion

Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
2 years ago
Solved

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.

 

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

 

3 Replies