100% stacked bar chart sort X-axis using using selected category slicer.

[Anonymous]

Hi Community,

I have one category slicer and it's category is early dispetch, late dispetch, dispectch at same day and not dispetch.
100% sctecked bar chart have four measure which represents simple count of four category value on x-axis and Y-axis have region column.

here i want to
1. when i select any of one category (Ex,dispectch at same day ) in category salicer then 100% stacked bar chart shows the first category as dispectch at same then after rest of category is displayed.
2. when i selecte random two categorys (Ex,dispectch at same and late dispetch) then it will display the selected two categorys first on x-axis in chart then after rest of the category is display.

Thanks
Finaz

[bhanu_gautam]

@Anonymous , You can create a measure for sorting

        SelectedCategoryOrder =

        VAR SelectedCategories = VALUES('YourTable'[Category])

        RETURN

        SWITCH(

            TRUE(),

            "dispectch at same day" IN SelectedCategories, 1,

            "late dispetch" IN SelectedCategories, 2,

            "early dispetch" IN SelectedCategories, 3,

            "not dispetch" IN SelectedCategories, 4,

            5

        )

Go to the Data view. - Select the Category column. - In the Column tools tab, click on "Sort by Column" and select the SelectedCategoryOrder measure.

Update the Visualization:

Go back to your report view.
Ensure that the 100% Stacked Bar Chart is sorted by the Category column, which now has the custom sort order applied