How to add/display financial year to a filter

[YXX]

Hi all,

I am new to community, I have a question about desktop fileter.

I try to add the new financial year to fileter below, I've checked the new finanical year is in the data model already.

Could someone show me the direction?

Thanks.

[YXX]

Now I want to check whether I can select one month and 2 financial years for comparsion, seems not working.

[YXX]

@AlanP514 @parry2k I sorted it out, just select month of Jul then I can see new finacial year in the slicer.

[AlanP514]

Hai @YXX 

Can you please remove sensitive data and pls share the pbix file here

[parry2k]

@YXX so one of the filters is causing it not to show, can you make a duplicate page and unselect all the filters and see which one is causing it, it is very hard to tell without looking at pbix file, so you have to test at your end.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[YXX]

@parry2k, it seems the financial year already in the data, but I have trobule to add it on the slicer. (I thought I can add it from Fliter-"add data fields here")

[parry2k]

@YXX do you have any other page-level/report-level filters?

[YXX]

@parry2k, please see below other report level-filter. 

I try to change it in the Field, but no luck.

Other tab/page, I can see the new finanical year from filter. (so this is setting for filter not data source.)

[parry2k]

@YXX where do you see that you have a new financial year in your data that it is not showing up in the filter?

[YXX]

@parry2k, I see it from data view. (from column "Financial Year")

[parry2k]

@YXX there is no extra action required if the financial year value is already added to the column, make sure to refresh the tables to get the most recent data from the source.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[YXX]

Thanks for you quick response.

Now I can't find the financial year in the filter selection, how to add the new one in the filter?