Forum Discussion

BojepJoe's avatar
BojepJoe
New Member
11 months ago
Solved

Multilevel Custom Sorting Clustered Column Chart

Hi, I have a chart with drill down for each category. I want to sort the x axis on each level based on my own custom order. For example this milk category have different size that I want to sort exa...
Need Help
  • rohit1991's avatar
    rohit1991
    11 months ago

    Hi BojepJoe 

     

    To get multilevel custom sorting in a clustered column chart:

    1. Create Sort Tables

      • One for Category with your custom order (Category, SortKey_Category).

      • One for Subcategory with order inside each category (Subcategory, SortKey_Sub).

    2. Model Setup

      • Relate Fact[Category] <<CategoryOrder[Category].

      • Relate Fact[CatSubKey] << SubcategoryOrder[CatSubKey].

    3. Sort by Column

      • In Model view:

        • Category<<Sort by SortKey_Category.

        • Subcategory<<Sort by SortKey_Sub.

    4. Hierarchy & Visual

      • Build a hierarchy: Category<<Subcategory.

      • Place it on the X-axis of your clustered column chart.

      • Enable Drill Down to move between levels.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi BojepJoe,

 

Just following up to see if the Responses provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar