Default value in slicer - single select drop down

[akiko_lim]

Hi there,
I want to be able to default a value in single select drop down every time a page is being loaded (1st time-load). I went through old postings and there are some workarounds suggested, however they don’t work for my scenario.

Default Value for a Slicer

My visual returns the correct values when a slicer selection is made. However, the visual errors out when no selection is made. What can I do to have a default value selected if the slicer is cleared? Thanks for your help. Regards, Rupert

Select latest date in Slicer

This is the slicer I need to default to the current days date. I’m just now sure how to do that based on what you mentioned above. It needs to always be up to the current date in the PBI service. The only way I can do that is to remove it and use a ‘DayOffset’ value of <= 0 but then the date cannot be changed. [image]

Use Case:
Default the selection to be the “last shift available” every time user loads the report (1st time-load of the report)

E.g.
Shift available

User A - launched the report and drop down will auto-select last shift available - “2019/04/30 (Night)”. User selected diff shift = “2019/04/28 (Morning)” … then closed the browser/report

10 mins later , User A re-launched the same report, and the drop down will auto-select shift “2019/04/30 (Night)”.

If data refresh happened where there is a new last shift available in the dataset, I would like the report to auto-select the last shift as well.

thanks

[ells]

Why not use a measure called last shift, then you can use SWITCH - if there is a selected val;ue retrun that if not then do a calculation for the latest shift.

Hope that helps
E

[Despo]

Have you tried creating a measure that finds the “Max” shift available and using that as a helper?

[EnterpriseDNA]

Hi @akiko_lim we’ve noticed that no response has been received from you since the 12th of August. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

[datazoe]

Hi @akiko_lim,

Usually when I want to have the default be the most current value, as in latest date or latest sprint, I create a calculated column that determines that flags that value, such as “Current”/“Older”. For yours, it could be the max night shift, provided they have a sort that will show it, which it seems it does for it to be at the top of the slicer.

Shift Group = if(ShiftsTable[Shifts]=CALCULATE(MAX(ShiftsTable[Shifts]),all(ShiftsTable)),“Current”,“Older”)

This can then be added in this slicer you have, making it a hierarchical slicer (which slicers support by default now). Then simply choose “Current” group as your default slicer option. They should always have the most recent selected first, and then they can choose a different one if they want. You can expand the whole slicer by right clicking on one in the dropdown, and choosing “Expand” --> “All”.

To get around the user filters, then comes back, there is an option in report settings to “Don’t allow end user to save filters on this file in the Power BI Service”, it’s the top option going File --> Options and Settings --> Options --> Current File --> Report Settings.

Hope this helps, and if you need more explanation, let me know and I’ll provide an example.

[akiko_lim]

Thanks Datazoe,

Let me try this. Appreciate your input.

[EnterpriseDNA]

Hi @akiko_lim, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!