Forum Discussion
Julia1234
Helper I
Helper ISet default dynamic ForecastPeriod in single-selection slicer
Hi,
I have a flat table with ForecastPeriod (text) and Sales (Decimal).
How to configure the slicer to show default ForecastPeriod dynamicly based on max/latest dynamic ForecastPeriod available?
Any Dax can handle this? But the exact ForecastPeriod should be preselected, not just words "Latest". Thank you
Table:
| Forecast Period | Sales |
| 2022-09 | 711 |
| 2022-09 | 714 |
| 2022-09 | 716 |
| 2022-08 | 300 |
| 2022-08 | 713 |
| 2022-08 | 716 |
| 2022-07 | 100 |
| 2022-07 | 712 |
| 2022-07 | 715 |
| 2022-05 | 716 |
| 2022-04 | 717 |
| 2022-05 | 718 |
| 2022-03 | 719 |
1 Reply
Hi Julia1234 ,
Unfortunately, the default slicer value cannot be set currently in Power BI.
Please check the following idea:
Default Selected Slicer or Tile-By Value Configuration Microsoft Idea (powerbi.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
