How to Order wise align clusterd chart

[Anonymous]

i have created clusterd column chart  Using measure with  total value 

Below measuer i used in the graph : 

Total Month =

IF(SELECTEDVALUE('Total Month variation'[Reduction buckets])="Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Total Month variation'[Reduction buckets])),

SUM('Master Data Base'[Value]))

Now  i have created calculated column  like 

Total Month variation = UNION ( VALUES ( 'Master Data base'[Reduction buckets]), ROW ( "Reduction Buckets", "Total Month Variation" ) )

Now  my Grpah looks like 

I want to make this graph order wise  like below 

any idea . thanks in advance 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see attachment), please check whether that is what you want.

1. Create a sorted table by manual typing. You can also put this sorted table on a cloud-based file (e.g. OneDrive), which makes it easy to maintain and refresh later.

2. Select the field "Reduction buckets" and sort by column "Order"

3. Update the formula of your measure [Total Month] as below:

Total Month = 
VAR _selbucket =
    SELECTEDVALUE ( 'OrderTable'[Reduction buckets] )
RETURN
    IF (
        _selbucket = "Total Month Variation",
        CALCULATE (
            SUM ( 'Master Data Base'[Value] ),
            ALLSELECTED ( 'OrderTable'[Reduction buckets] )
        ),
        CALCULATE (
            SUM ( 'Master Data Base'[Value] ),
            FILTER (
                'Master Data Base',
                'Master Data Base'[Reduction buckets] = _selbucket
            )
        )
    )

4. Create a clustered column chart(Axis:Reduction buckets of table OrderTable Values: Total Month)

Best Regards

[Anonymous]

i have created clusterd column chart  Using measure with  total value 

Below measuer i used in the graph : 

Total Month =

IF(SELECTEDVALUE('Total Month variation'[Reduction buckets])="Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Total Month variation'[Reduction buckets])),

SUM('Master Data Base'[Value]))

Now  i have created calculated column  like 

Total Month variation = UNION ( VALUES ( 'Master Data base'[Reduction buckets]), ROW ( "Reduction Buckets", "Total Month Variation" ) )

Now  my Grpah looks like 

I want to make this graph order wise  like below 

any idea . thanks in advance