Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper V
Helper V

Show data based on slicer selection

Hello All,


I have table where I am having daily data like date,sales,profit and discount.


My requirement is I need to show a slicer which have values like daily,weekly,monthly and Quarterly.

If the user selects daily I need to show last 30 days sales,profit and discount.

If the user selects Monthly I need to show last 12 months data.(Here I need to aggrigate data for monthly)

If the user selects Weekly I need to show last 12 Weeks data. (Here I need to aggrigate data for Weekly)

If the user selects Quarterly I need to show last 4 qtrs data. (Here I need to aggrigate data for qtrly)


So I created a table in power bi with these values and showing as slicer.

Not sure how to write the dax to calulate these.



Sample Data :




Could any one please help on this

Super User
Super User

@Sathvik123 , Have these as the name of Date, Month , week and Qtr column, you want to display on axis


rolling 12 =  // Same for month and qtr
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = date(Year(_max), month(_max) -12, Day(_max))+1
CALCULATE([net] ,filter(Date, Date[Date] >= _min && Date[Date] <=_min))





var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = _max -30
CALCULATE([net] ,filter(Date, Date[Date] >= _min && Date[Date] <=_min))



for week you need use week rank column in date table

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format


Last 12 weeks = CALCULATE(sum('Table'[Qty]), FILTER(('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-11 && 'Date'[Week Rank]<=max('Date'[Week Rank])))


Now use the field parameter on the renamed column of date table and change the measure as suggested in blog


selected parameter code is important

Switch TOPN with Field Parameters:


Hi @amitchandak ,


In the below calculation what is meant by [net] ?


CALCULATE([net] ,filter(Date, Date[Date] >= _min && Date[Date] <=_min))

@Sathvik123 , here net is my measure. You can use your measure

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors