topic Re: Line chart and Tachometer interaction in Developer

Line chart and Tachometer interaction

devika — Tue, 03 Jan 2023 23:09:52 GMT

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)

Re: Line chart and Tachometer interaction

v-jianboli-msft — Wed, 04 Jan 2023 03:17:53 GMT

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.

Re: Line chart and Tachometer interaction

devika — Wed, 04 Jan 2023 05:57:32 GMT

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