Тёмный

Set Default Slicer Selection to Today's DATE in POWER BI 

Santosh Pothnak
Подписаться 962
Просмотров 20 тыс.
50% 1

In this Video we are going to look at the logic for setting the default slicer selection to Today's Date in Power BI. Enjoy and.... subscribe, like and comment :)
If you have any doubts please comment below!!
Download the pbix file in the below link -
drive.google.com/file/d/165AM...

Опубликовано:

 

12 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@rashmimkonnura1136
@rashmimkonnura1136 2 года назад
Bro ,very clean very straight forward. Keep going bro ..v except more vids from u
@martinstrnad6860
@martinstrnad6860 2 года назад
Could you tell me hot to make that Today vaule as default? I mean for example when i open that report there will be selected today as default value for that slicer and not all as i have now
@anilkumaryarra5468
@anilkumaryarra5468 2 года назад
Great explanation 👍.. Is this work for multiple columns like year, quarter, month and date of course new calculated column in a slicer visual when month is changing from 31 to 1.
@nanu9432
@nanu9432 2 года назад
I am currently working on making a date slicer default as yesterday. data should show from beginning till yesterday’s date. and also allow users to choose any date they want. Is this possible in power bi ? I would appricate any help.
@chintansolanki9955
@chintansolanki9955 2 года назад
I have calendar which have date, fortnightly date and rest others. For example, I have fortnightly column from 3 jan 2022 to 15 jan 2022 and if today falls between this two date period, I want to show that fortnightly duration in a slicer. It there any way to do so? Hope it makes sense.
@monazaizan947
@monazaizan947 Год назад
Great solution. However it won't work on between style slicer and it is frustrating! Any idea how to tackle this? Users prefer to use between style slicer rather than other options.
@ravikumar-wj3rr
@ravikumar-wj3rr 2 года назад
very nice sir
@juanpablovivar1088
@juanpablovivar1088 2 года назад
default month selection on slicer is my question, thanks
@juanpablovivar1088
@juanpablovivar1088 2 года назад
but if the user want to change the month, they can do it,
@juanpablovivar1088
@juanpablovivar1088 2 года назад
great, how can create slicer with the month name that contain all the months, at the momenth in your example disappear all the name, except actual month, thanks
@santhoshkumarj1543
@santhoshkumarj1543 2 года назад
You are selecting the "Today" in slicer.. but by default the selection should have happened in slicer based on current date right
@varshakrishna7918
@varshakrishna7918 2 года назад
Exactly that’s what I was looking for
@treesachacko6864
@treesachacko6864 2 года назад
Hi, thank you for sharing this.I tried this. But my slicer is not sorting the dates properly as it has been converted to string data type. Is there any way to fix this. Please help. It’s urgent.
@moiLawUk
@moiLawUk 2 года назад
Hi thanks for the video. I have my date as a 'from date' and 'to date'. how do i set the 'to date' to yesterdays date please?
@akashragi2347
@akashragi2347 2 года назад
Instead of a today string can I display Today’s date in date format?
@annagraham-yq7dr
@annagraham-yq7dr Месяц назад
How do I make this British with DD/MM/YYYY?
@user-kv1si3bq3z
@user-kv1si3bq3z 4 месяца назад
How to do for between date slicer
@siddheshamrutkar8684
@siddheshamrutkar8684 2 года назад
But how it can directly get selected.. In the slicer..
@kummithavenkatareddy2302
@kummithavenkatareddy2302 2 года назад
I have data up to NOV 2021 when i am WORKING in 2/Feb/2022. I have created calendar using Min( Fact_Table[Billing-Date]), MAX(Fact_Table[Fisca-lDate]). Now in my slicer i want to show latest Month NOVEMBER dynamically (by NOT selecting manually) & Previous Months. If I get any data like in Dec2021 in the back end, in the slicer i want to see Dec Month whenever i refresh the file. We are using USA fiscal policy. Use DAX ONLY FISCALDATE FOR ALL THE DATES IN NOVEMBER IS 6/1/2021 ( COMES UNDERS FY22 ACCORDING TO US FISCAL POLICY. I WANT ALSO SHOW PREVIOUS FISCAL MONTHS IN SLICER. bIILING DATE IS Nov/1/2021 fiscal date is Nov/1/2022
@YouTubeUTube1
@YouTubeUTube1 2 года назад
I want to show system date rather than today...pls help
@navaneetharajuramesh8462
@navaneetharajuramesh8462 2 года назад
Hi Brother, I have question , i have a data of 4 years, 2018,2019,2020,2021. If i open a report in power Bi desktop or power bi service, Year should show the default "2021" with that year data. how we did this??????? Please advice. - URGENT.☺
@nandhakumar6480
@nandhakumar6480 2 года назад
Did you achieved this?? If Yes ,Kindly share the details .I need urgent
@navaneetharajuramesh8462
@navaneetharajuramesh8462 2 года назад
@@nandhakumar6480 I got the result from Gorilla BI channel. There he done a power query m function. I suggest you to watch that video. It's works
@nandhakumar6480
@nandhakumar6480 2 года назад
@@navaneetharajuramesh8462 Any link please ?
@navaneetharajuramesh8462
@navaneetharajuramesh8462 2 года назад
@@nandhakumar6480 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-JlVHsZUk1nc.html
@nandhakumar6480
@nandhakumar6480 2 года назад
@@navaneetharajuramesh8462 But My requirement is I have a date col in my table all the row starts with day 1 of every month and year example : 1.1.2020 1.2.2021 1.5.1995 1.6.2021 If I used date slicer with between or relative date slicer option . I want to see only available dates in visible mode others should be hide or blur in date picker .or some other work around .
@happyfase
@happyfase 8 дней назад
The fact that this isn't a tick box in Power BI is a joke.
Далее
Alisha Lehmann joins Juventus Women 🤍🖤
00:16
На чем играют ПРО | Standoff 2
07:25
Просмотров 303 тыс.