Forum Discussion
Show current year data if no filter is selected
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!
Hi Anonymous ,
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.
3 Replies
- amitchandak
Super User
Anonymous , 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())))
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 !!
Hi Anonymous ,
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.
