Line chart and Tachometer interaction

[devika]

Hi All,

I'm looking to build a line chart and tachometer interactively.

The tachometer graph should default to the last quarter whenever the report is opened.

I have solved showing it to default to the last quarter by adding the filter to the visual.

But when the user hovers over the line chart, the gauge chart should show the values of that data point, but it is showing blank.

Here is the data table

Fields Pane:

( I have got dummy data here, but above is the concept I'm trying to work out)

[devika]

Thanks for your time solving it and it is working as expected

[v-jianboli-msft · Accepted solution]

Hi @devika ,

Please try:

Measure = 
var _a = ADDCOLUMNS(ALL(Sheet1),"YearQuarter",YEAR([Month])*10+QUARTER([Month]))
var _b = MAXX(_a,[YearQuarter])
var _c = MAXX(FILTER(_a,[YearQuarter]<_b),[YearQuarter])
return IF(ISCROSSFILTERED(Sheet1[Sales Amt]),SUM(Sheet1[Sales Amt]),CALCULATE(SUM(Sheet1[Sales Amt]),FILTER(_a,[YearQuarter]=_c)))

Apply it to Tachometer

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.