Show current year data if no filter is selected

[tutuk28]

Hi all!

I have a table that shows names (text type) according to the selected year.

Is there a possibility that if I don't select any year in the slicer it will show me the names of the current year in the table?

Thank you!

Regards!

[amitchandak]

@tutuk28 , not sure what you mean by table.

You can show year like

Measure = year(Today())

data measure

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=today())))

[tutuk28]

Hi @amitchandak !

I have a table visual that only shows names of people (Text type).

These names are in my fact table that is related to the time dimension.

In this page I have a slicer where you can select years and according to the selected year the people will change.

I want that if there is nothing selected, it shows me the names of the current year and not all the names that exist.

In the way you have proposed in your answer it could not be done.

Thanks !!

[v-jayw-msft · Accepted solution]

Hi @tutuk28 ,

You can create a measure as below and add it to visual filter.

Measure = 
var selected_year = IF(ISFILTERED('date'[year]),SELECTEDVALUE('date'[year]),YEAR(TODAY()))
return
IF(SELECTEDVALUE('Table'[year])=selected_year,1,0)

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.