Queries

[Anonymous]

I have a few challenges

1) When I click on date function the dashboard is refreshing. But is very hard to see refresh ( wheel) option. Is there any way to setup refresh option ICON much bigger?

2) The Date format in the slicer showing as 1/29/2020 though it set was "mm/dd/yyyy" format at the backend. How to cange date format in the slicer?

3) I have date slicer which should display default value( todays date) whenver report open up?

4) How to do sorting for Drill Through values to inline with Tabs order?

Example: Tab1,Tab2,Tab3

when select drill through option - the values are shuffled

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Anonymous ,

Sorry for replying late.

1) I'm afraid not, it is set by design in power bi and we could not change it manually.

2) The date format display in the slicer visual decided by the local client Regional settings. Please refer this issue: date format in slicer 

3) If it means dynamic slicer value, power bi could not support it currently, you can create an idea here, or you can refer these simliar issues:

• dynamic default value date slicer 
• Set default value for slicer  

4) You can vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=04ce5fcf-4fed-4a3e-9383-f1b529399a0e

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt 1 and 4 are possible.

for 2, you have change the date format at column level

For three you have create a column like this and use it as page-level filter

Date Name = Switch( True () ,
'Date'[Date]=TODAY(),"Today",
'Date'[Date]=TODAY()-1,"Yesterday",
'Date'[Date]=TODAY()-1,"Yesterday -1",
[Date]&"")

Sort this on the date column and use today as the filter