Forum Discussion

schoden's avatar
schoden
Post Partisan
6 years ago

Re: add forums for all platforms in https://ideas.powerbi.com/

Hi  I am new to Power BI and learning still. I needed to filter relatively data for current fiscal year- July as Start month. I have created date table with fiscal year and all. It is completed. N...
  • schoden's avatar
    schoden
    Post Partisan
    6 years ago

    hi v-lid-msft 

     

    I have created fiscal year from July in date calender thats working pefectly. 

     

    I want to filter page not with a slicer but relative filter on page so that the THIS fiscal year is selected, which will dynamically change as June of that year ends and Next July comes as current fiscal year again. 

     

    I want to automate like above.

    • schoden's avatar
      schoden
      Post Partisan
      6 years ago

       

      Hi v-lid-msft  Please find the snap of it. I want to filter the page with relative date filtering so fiscal year is chosen.  But I get calender year Jan  as start month, there is no option to choose Fiscal Year , it doesnt pop up in the drop down menu.