Do you want challenge? This will make you cry!

[prettyboyboga]

Once again I am trapped with no ideas, so here is my problem: I have the Tachometer and Timeline Visual downloaded from PowerBi and wanted to do a measure on the graph but here is the catch, I only want to calculate the latest month that the graph will be showing based on what is selected in the Timeline. Example in the Graph, the latest month is showing Jan 2018, but the Tachometer named Rating is calculating all of the Months in the Graph and i only want to calculate what will be the latest month that will be showing. I have the current measure showing as well in the picture. 

Is my idea doable in PowerBi? thank you so much!

 

[v-shex-msft · Accepted solution]

HI @prettyboyboga,

Do you mean break filter effect on tachometer from timeline slicer and only calculate with last month?
If this is a case, you can try to break interaction from timeline slicer and add specific filters in your measures.(last month date range)

For example:

Current = 
VAR _lastdate =
    MAXX ( ALL ( 'Table' ), [Date] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Amount] ),
        FILTER (
            ALL ( 'Table' ),
            YEAR ( 'Table'[Date] ) = YEAR ( _lastdate )
                && MONTH ( 'Table'[Date] ) = MONTH ( _lastdate )
        )
    )

If above not help, please share some sample data for analysis.

Regards,
Xiaoxin Sheng