sort GapAnalysis Graph by Gap

Deepika

You can create a gap column with following formula and put it into the field of “Sort Statements By”. I test with the sample file downloaded in custom visual library. Uploaded the PBIX file here for reference.

Gap = 
ABS (
    'Point of sale drivers'[Sales]
        - CALCULATE (
            SUM ( 'Point of sale drivers'[Sales] ),
            FILTER (
                'Point of sale drivers',
                'Point of sale drivers'[Drivers] = EARLIER ( 'Point of sale drivers'[Drivers] )
                    && 'Point of sale drivers'[Year] <> EARLIER ( 'Point of sale drivers'[Year] )
            )
        )
)

Best Regards,

Herbert