Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Visual Gauge with YoY% quick measure - unknown default value

Hi Dears,

 

I have a problem, with Gauge visual when nothing is selected. I added there YoY% quick measure and when I select data from visual which is next to it Gauge shows correct information, but when nothing is selected I got % which I dont understand from where it comes from.

Not selected - incorrect 10.17% 

Artur1239_0-1677227200390.png

 

Selected - correct information

Artur1239_1-1677227245018.png

How to show blank or 0 when nothing is selected ?

1 REPLY 1
Anonymous
Not applicable

This is how DAX looks like, please help to solve it

 

Count of Credit Memo number YoY% =
IF(
    ISFILTERED('ETO FY19-22'[Creation Date]),
    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
    VAR __PREV_YEAR =
        CALCULATE(
            COUNTA('ETO FY19-22'[Credit Memo number]),
            DATEADD('ETO FY19-22'[Creation Date].[Date], -1, YEAR)
        )
    RETURN
        DIVIDE(
            COUNTA('ETO FY19-22'[Credit Memo number]) - __PREV_YEAR, __PREV_YEAR, "0"
         
        )      
)

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.