Forum Discussion

vipett's avatar
vipett
Icon for Helper III rankHelper III
9 months ago
Solved

Wrong number formatting data label when highlighted

I have a simple graph with a measure "On time" which is formatted as %, normally it looks fine   But if I highlight a category or country or anything it loses its data formatting:  ...
Need Help
  • vipett's avatar
    vipett
    8 months ago

    It sounds reasonable, but still doesn't work..

    Luckily this was not in a Production file, but just connected to a test environment and in the production environment it worked without any workarounds..

ChielFaber's avatar
ChielFaber
Icon for Super User rankSuper User
9 months ago

Could you show us the measures your using? 

 

Try creating a measure with an assigned format:

OnTime % (Formatted) :=
VAR v = [OnTime %]
RETURN FORMAT(v, "0.0%")

  • vipett's avatar
    vipett
    Icon for Helper III rankHelper III
    9 months ago
    On-time % (orders) =
    VAR OrdersScope =
        SUMMARIZE(
            'Purchase Order Line',
            'Purchase Order Line'[DIM_COMPANY_KEY],
            'Purchase Order Line'[DIM_SITE_KEY],
            'Purchase Order Line'[Order No]
        )
    VAR OrdersEval =
        ADDCOLUMNS(
            OrdersScope,
            "__Eligible",
                CALCULATE(
                    COUNTROWS('Purchase Order Line'),
                    ALLEXCEPT(
                        'Purchase Order Line',
                        'Purchase Order Line'[DIM_COMPANY_KEY],
                        'Purchase Order Line'[DIM_SITE_KEY],
                        'Purchase Order Line'[Order No]
                    ),
                    NOT ISBLANK('Purchase Order Line'[DatediffPromied])
                ),
            "__Late",
                CALCULATE(
                    COUNTROWS('Purchase Order Line'),
                    ALLEXCEPT(
                        'Purchase Order Line',
                        'Purchase Order Line'[DIM_COMPANY_KEY],
                        'Purchase Order Line'[DIM_SITE_KEY],
                        'Purchase Order Line'[Order No]
                    ),
                    NOT ISBLANK('Purchase Order Line'[DatediffPromied])
                        && 'Purchase Order Line'[DatediffPromied] >= 1
                )
        )
    VAR TotalEligibleOrders =
        COUNTROWS( FILTER(OrdersEval, [__Eligible] > 0 ) )
    VAR OnTimeOrders =
        COUNTROWS( FILTER(OrdersEval, [__Eligible] > 0 && [__Late] = 0 ) )
    RETURN IF( TotalEligibleOrders = 0, BLANK(), DIVIDE(OnTimeOrders, TotalEligibleOrders) )