Based on Slicer selected Year change Month Order

[punati33]

I am implementing following solution .

Based on selected year type on filter change the order of month 

Ex:

If i select "IndiaFinancialYr" in a slicer Month order should be April to March in Month Slicer

If i select "USFinancialYr" in a slicer Month order should be Jan to December in Month Slicer

Regards,

Praveen

[v-lionel-msft]

Hi @punati33 ,

It will be easy if you have such a table.

Use two slicers

Use hierarchical slicer

Best regards,
Lionel Chen

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

[punati33]

Issue was my user wants to have the capability of selecting type of year in this case {Either India or US } , then based on the year selection month should be displayed for respective financial year in the order

Regards,

Praveen

[v-lionel-msft]

Hi @punati33 ,

Has your problem been solved?

If not please show us a sample data, The data is preferably reproducible, in tabular form.

Best regards,
Lionel Chen

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

[amitchandak]

@punati33 , I do not think you can change order by column dynamically. You have change axis

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

You need to have both month year ready with sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

for Calendar refer : https://www.dropbox.com/s/wrcyk5j66corvjg/Apr2Mar-Cal.pbix?dl=0

Some time bookmark is used to change axis

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive