Forum Discussion

sheetalshettiga's avatar
sheetalshettiga
Icon for Helper IV rankHelper IV
6 years ago

Fiscal Year and Regular Year selection

Hello All            I have a slicer selection between fiscal and regular year .I have year and fiscal year column in calendar table.In KPI to show Sales Revenue what field should I keep in trend ax...
Show and Tell
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

I have created a sample for your reference.

Measure = var sel = SELECTEDVALUE(slicer[sele])
return
IF(sel="Regular",SUM('Table'[value]),CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[date] in VALUES('date'[FY]))))

 

Pbix as attached.

 

sheetalshettiga's avatar
sheetalshettiga
Icon for Helper IV rankHelper IV
6 years ago

In the screenshot attached i have issue with the current year and previous year KPI.since in the trend axis the coulmn should change based on selection of fiscal and regular year i am getting issue.can you take this scenario and help me out