Welcome to my RU-vid channel! I'm Santosh Pothnak, with 14 years of experience in IT currently working with Accenture as a Senior Power BI Developer. I'm also the mind behind Analytics Discovery Hub, a friendly community where BI Analytics enthusiasts, Power BI beginners, learners, developers, and working professionals unite to learn and grow.
With a history of guiding over 50,000 students on Udemy since 2020, I'm passionate about making the world of Power BI and analytics easy to understand. Here, you'll find a treasure trove of Power BI Free Tutorials, where I'll be sharing tips and tricks to help you become a pro in no time.
Join me on this journey as we unravel the secrets of analytics together, empower ourselves with valuable skills, and take steps towards landing that dream job. Let's dive into the exciting world of analytics and Power BI!
i have a problem in PQ in Excel (2019 v)... data preview tab in power query at excel shows only two options ( whitespace - monospaced ) how i show column quality option ? all the best...
Hello Santosh! When I try to open the doc. dowloaded "Power BI Dev" the following message appears: "Remote Desktop Connection requires Parallels Desktop to operate. Please install Parallels Desktop and try again." How can I open the doc to enter with the pin?
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.
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.
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
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.
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
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.☺
@@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 .
