Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to 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.
Thanks for your time solving it and it is working as expected
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.