Forum Discussion
Line chart and Tachometer interaction
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)
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.
2 Replies
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.
Thanks for your time solving it and it is working as expected
