Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.