Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Whenever user selects any year value from filter pane, in dashboard should display that year and previous year data? how do you achieve it
You can achieve this by adjusting the measures used on the dashboard with set analysis modifiers.
If your current dashboard expression is SUM(Sales) then you can adjust which years that are taken into the calculation by adding a set modifier like this.
SUM({$<Year={">=$(=max(Year)-1)"}>}Sales)