Fiscal Year and Regular Year selection

Question

Hello All&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;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 axis so that based on my selection on fiscal year and regular year the result should change.Since my year and fiscal year are columns i cannot write a measure for the selection to add in trend axis.please help me with this

amitchandak · Answer

sheetalshettiga , For toggle of the axis, you might have to use a bookmark. Have two visuals. Hide nad show
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

v-frfei-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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]))))

&nbsp;
Pbix as attached.
&nbsp;

anonymous · Answer

Can you show a snap to make an idea

sheetalshettiga · Answer

I have included calendar year in Trend axis so when i select Fiscal i get wrong result of revenue. How can i toggle selection in Trend axis for year and fiscal year

anonymous · Answer

Probably the same advice like&nbsp;amitchandak provided to use bookmark and that's the easiest way.&nbsp;

Forum Discussion

Fiscal Year and Regular Year selection

7 Replies

Related content

Regular expression

Regular Expression Functions (REGEX) in Power Query

Dynamic Filter Selection Behavior in Power BI -Fiscal Year/Period

LY Fiscal Calculation

Fiscal Year and Fiscal Quarter