cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cherukuri19 Frequent Visitor
Frequent Visitor

How to set Current Financial year Filter to be Last 5 FY from today

Hello Friends, 

 

In my Power BI desktop I have connected to SSAS Multi Dimensional cube as a data source. 

in my Date table has by default showing from 1889/90 so basic filter is showing by default first 1000 years only. in my dashboards I would like to filter last 5 Financial filters only. basically i know 2015/16 is a string. which is first requirement I want ! 

 

My second require ment is : 

rather having to use the filter to pick those years individually. So what I’m saying is to dynamically work out in the model the last 5 FY from today.

 

Thanks in advance. 

3 REPLIES 3
Super User
Super User

Re: How to set Current Financial year Filter to be Last 5 FY from today

Well I assignment you can just apply a filter in the query that imports the data. I have never tried it with SSAS, but I assume there is the same date filter options in the query. If hat doesn't work, why don't you create your own calendar in Excel. It doesn't have to come from SSAS as the source, even if your other data does. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
cherukuri19 Frequent Visitor
Frequent Visitor

Re: How to set Current Financial year Filter to be Last 5 FY from today

Hi Mallington, 

 

Many Thanks for your reply. 

I am directly connecting to the SSAS Cube so then My Date dimension is linked to all my measures ) as you said If I create my own calendar in excel how can I connect to my measures. sorry I didn't get you. 

 

 

greggyb New Contributor
New Contributor

Re: How to set Current Financial year Filter to be Last 5 FY from today

@cherukuri19, if you want to use your own date dimension from e.g. Excel, you'd have to import the data to Power BI's data model and create relationships there rather than using a live connection to SSAS.

 

Otherwise, you could request a Last5FiscalYears flag in the cube that would allow you to set a report-level filter to filter out rows that don't have that flag.