Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I have ich Slicer with
2019/1
2018/4
2018/3
and choose SINGLE SELECT with 2019/1. But when I get new Data with 2019/2 the choosen Button is still 2019/1. Can I control that? I want that the SINGLE SELECT is always the newest one.
Many thanks.
Hi powerbityro
As I know, we can’t use a measure in Slicer, so if you want to make slicer always select newest date, you could try to use below method, create a column like below, then use this for Slicer
Column = if('Table'[Date]=MAX('Table'[Date]),"a",'Table'[Date]&"")
You could refer to video or Power BI Tutorial: Dynamically update Date slicer to show Current Date for details.
In addition, if you want to get the newest day based on current day(today), you also could use relative slicer, it will automatically change
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @powerbityro
Many posts with the same question.
https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/td-p/16442
https://community.powerbi.com/t5/Desktop/KPI-Filtered/m-p/274022#M122559
And more if you search.
Cheers!
A
It is possible to use
if Date.IsInCurrentMonth( [Date] )
then "Current Month"
else [Month]
with Output current date 2019/1 instead of the text "Current Month"?
I have no Date. Only Year and Quarter and Year/Quarter.
I work in Direct Query Mode... so both solutions... MAX in Column and
if Date.IsInCurrentMonth( [Date] )
then "Current Month"
else [Month]
is not accepted. Is it than not possibe in DQ Mode or do you have some further ideas?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |