Filters effecting Sorting order

[#1]

Hi everyone,

I have 3 monthly trend charts Costs, Benefits and Checks and respective filters.

When i select a Check Type in filter then sort order of Month Dimension in other 2 charts is altering when compared to initial state.

but, this is not happening when i select other 2 filters.

I couldn't figure it why its happening.

P.S: Month, Year are Synthetic keys

Please find the attachment. 

Help is much appreciated

Thanks

[maxgro]

sort MonthName by numeric value (remove the other sort)

[#3]

Hi Maxgro,

Its like that, still causing problems.

Thanks

[maxgro]

I get this selecting Check Type. If it's not correct, what do you want to achieve?

[#5]

I see the difference in mine. if i select same thing. See Benfits charts. Can you confirm me that other 2 charts are not changing the sort order select differt Check Type

[#6]

Hi,

The problem is not into it is the data.
Evidently not having data for all months of every year, the selection of a Check Type, the costs are shown in alphabetical order, but always by Year.
How to Use MonthYear size should solve

Regards

Gennaro

[#7]

Thanks Gennaro.

I cant use MonthYear, because if there are many year the chart looks weird.

Is there any solution except this with the same data?

[#8]

Yes you can use the number of Month.

In your data you have a field called Month, but you can not use in the app because it is a reserved word.

Change Mounth field in MounthNum and use it to order graphics.

[#9]

Will give a try

Thanks

[#10]

It didn't help. because it also associated with MonthName.

Thanks