Visual with most recent Fiscal Year from Filtered Selection

dwelsh — Thu, 04 May 2023 21:45:11 GMT

I am trying to create a Stacked Column Chart visual that will only display the most recent fiscal year from the user's filtered Fiscal Year selection. For instance, if the Fiscal Years selected are those in the image below, the Stacked Column Chart visual would only have data for 2022.

I am currently trying to acheive this by creating a True/False column on my date table so that any date in the max fiscal year is assigned True and all other False. Then I can put the column as a filter on the visual and set it to True. I am having difficulty with creating the column.

Here are the columns/measures I have so far.

A measure to return the most recent fiscal year selected.

MaxFY = CALCULATE(max('Calendar'[Fiscalyear]),ALLSELECTED('Calendar'))

A column to set date within the fiscal year to true if they match the most recent fiscal year

IsMaxFY = IF( 'Calendar'[Fiscalyear] = 'Calendar'[MaxFY], TRUE, FALSE )

The MaxFY measure works and returns the most recent fiscal year selected (See below). The IsMaxFY column is not working. I want IsMaxFY to read True for the bottom row of the table.

Any suggestions on how to acheive this?

Re: Visual with most recent Fiscal Year from Filtered Selection

mrcss23 — Fri, 05 May 2023 18:14:07 GMT

Hi.

You can just use TOPN filter

use MAX of the YEAR

See pic

Re: Visual with most recent Fiscal Year from Filtered Selection

dwelsh — Fri, 05 May 2023 18:51:05 GMT

So easy, thanks mrcss23!

topic Re: Visual with most recent Fiscal Year from Filtered Selection in DAX Commands and Tips

Visual with most recent Fiscal Year from Filtered Selection

Re: Visual with most recent Fiscal Year from Filtered Selection

Re: Visual with most recent Fiscal Year from Filtered Selection