Unable to do the sorting due to page filter.

[Prag_02]

The sorting is working  properly ,but once the page filter is getting  applied ,the fiscal  year quarter is not working in sorted way  

i have tried adding index

[Prag_02]

The visulaization is not working sorted manner due to Legend . I  have to use bubble chart only .Can you please how to sort it with keeping the legend value .Also i can not have null or blank values in the view.
please suggest any solution  @CKKR  @Samarth_18 @Anonymous 

[Anonymous]

Thanks for the reply from @Samarth_18 , please allow me to provide another insight: 
Hi  @Prag_02 ,

Whether [sort] is created on [FY/Quarter] itself logically calculated, in the process of calculation, if A depends on B, at the same time B depends on A, the two objects are interdependent on each other then the engine does not know which object to be calculated first, leading to this error

Understanding circular dependencies in DAX - SQLBI

Here are two ways you can try:

1. Power BI default sorting is alphabetical, in general, in text format 2024Q1 this data style will be sorted normally, you can click on the yellow mark in accordance with the [FY/Quarter] to sort

2. You can manually create an Index by using Enter data or Power Query to create a new table with only [FY/Quarter].

Enter data：

In Power Query：

Add Column – Index Column – From 1.

Using Sort Table -- [FY/Quarter]  -- Column tools – Sort By column – [Index].

Joins the relationship between two tables:

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[CKKR]

Hi Liu Yang ,

thank you for providing multiple sort options.

BR,

KKR

[Samarth_18]

Are you creating a sorting column on the top of any custom column?

Is it possible for you to share your sample file?

[Samarth_18]

Hi @Prag_02 ,

You can use the sort by another column option in case you have not used yet.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

[Prag_02]

i added a sort order number or index number ,but then i am getting cricular dependancy . please suggest some idea ,i am clueless how to solve this