Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter Order is not as expected.

Hi All,   I have created simple Report using Power BI Desktop. and the report is having 3 filters 1. FiscalMOnthNumber 2. FIscalQuarter and 3.FIscalYear   The Current order of filter is : 1.Fis...
Need Help
  • affan's avatar
    affan
    7 years ago

    Anonymous

     

    You are right that it rearranges the order. I think you can acheive this through a little trick if feasible for you.

     

    Just rename the columns as A.FiscalYear , B.Quarter & C.Month

     

    Hope this would resolve your issue. :smileywink:

     

    Regards

    Affan

  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    the fields in FIELDS and FILTERS are set to sort alphabetically by default. and it can be changed for now.

    You could rename the fields by adding a prefix to sort them as a workaround for now.

    for example:

    3FiscalMOnthNumber
    2FiscalQuarter
    1FiscalYear

     

    For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

     

     

    Best Regards,

    Lin

affan's avatar
affan
Solution Sage
7 years ago

Anonymous

 

 

See the below illustration to acheive the result.

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

 

affan's avatar
affan
Solution Sage
7 years ago

Anonymous

 

You are right that it rearranges the order. I think you can acheive this through a little trick if feasible for you.

 

Just rename the columns as A.FiscalYear , B.Quarter & C.Month

 

Hope this would resolve your issue. :smileywink:

 

Regards

Affan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Affan,

     

    Thank You and i can rename but user wants column names should be same as above.

    Any other approach would be appriciated.

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      7 years ago

      hi, Anonymous

      the fields in FIELDS and FILTERS are set to sort alphabetically by default. and it can be changed for now.

      You could rename the fields by adding a prefix to sort them as a workaround for now.

      for example:

      3FiscalMOnthNumber
      2FiscalQuarter
      1FiscalYear

       

      For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

       

       

      Best Regards,

      Lin