Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

noelsamuel30

Need help in loading only fiscal year data based on month and year

Submitted by on ‎03-22-2023 04:02 AM

Hi Everyone, I have a table in which I have only Month_Year 01-2022, 02-2023 so on. My objective is to load data only fpr latest fiscal year that is 04-2022 to 03-2023. Based on month year is it possible to bring the fiscal years and limit the data as well using parameters or some other functionality. Any help will be appreciated. Thanks in advance.

 

 

Capture.JPG

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎03-22-2023 07:36 PM

Hi @noelsamuel30 ,

 

The following two threads describe the operation steps in detail.

How to Parameterize Data Sources in Power BI | phData

Dynamic Filtering Using Parameters in Power BI / Blogs / Perficient

 

 

Best regards.
Community Support Team_ Caitlyn

Idea Statuses