cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Deepika New Member
New Member

sort GapAnalysis Graph by Gap

Sort Gap Analysis graph by Ascending or Descending values by gap.Please help

1 REPLY 1
v-haibl-msft Super Contributor
Super Contributor

Re: 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] )
            )
        )
)

sort GapAnalysis Graph by Gap_1.jpgsort GapAnalysis Graph by Gap_2.jpg

 

Best Regards,

Herbert