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
8 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) )