
Completed
Posted
Paid on delivery
I have attached 2 pictures explaining what I want and also shared the file. More precisely, I would like the slicer to automatically select the latest week when I click on the Weekly button, without needing to update the bookmark every week (my data is weekly). Similarly, when I click on the Cumulative button, I want the end-period slicer to show the latest available week. Do you think you can help?
Project ID: 39728755
13 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I am Supriya Kumari, [login to view URL] from IIT Dhanbad (QS ranked), with 7+ years of experience in data systems, automation, and advanced Power BI solutions. I specialize in building interactive dashboards with smart automation, dynamic DAX measures, and slicer controls that eliminate repetitive manual updates. I understand your exact requirement: when you click the Weekly button, the slicer should automatically select the latest week without you updating bookmarks; and when you click the Cumulative button, the end-period slicer should always show the latest available week. This can be achieved by designing dynamic measures in DAX (e.g., IsLatestWeek, Cumulative) and linking them with button logic, so your slicers update automatically with new data—no manual intervention needed. I can directly update your PBIX file with: Automated slicer defaults (latest week selection) Dynamic cumulative logic tied to the latest available week Clean button navigation without requiring bookmark refreshes Clear documentation so you can maintain it easily I’ve built similar automated dashboards for clients where slicers, KPIs, and filters adjust dynamically as new data flows in. Money is not a constraint—I value delivering a robust, user-friendly solution. I can deliver this quickly and efficiently. Looking forward to collaborating with you on this.
₹600 INR in 1 day
2.7
2.7
13 freelancers are bidding on average ₹1,354 INR for this job

As an Excel and Power BI expert, I am well-equipped to address your urgent need for automatic data updates in slicers using bookmarks. With a robust understanding of data analysis, calculations, and charting within Excel, I can ensure that the slicer's selection aligns with the latest week as desired. This proficiency extends seamlessly into Power BI – a tool I use daily to visualize data and create dynamic reports. Moreover, my comprehensive knowledge of Visual Basic (VB), VBA automation scripts, and UI/UX design adds extra value to my Power BI expertise. This affords me the unique ability to not only develop interactive visualizations but also craft user-friendly designs for an enhanced experience. For your specific requirements, I can leverage these skills to automate repetitive tasks and ensure intuitive slicer functionality based on weekly selections. In addition, I bring with me solid experience in integrating multiple data sources in Power BI. This means I can expertly handle any complexities associated with your weekly dataset, assuring consistency across these dynamic slicers. Trust me when I say that this is not just another project for me; it's an exciting challenge where I can fully apply my expertise to provide you with a solution that perfectly matches your needs. Let's get started on creating a seamless automated system for you!
₹1,500 INR in 1 day
2.9
2.9

Hi! Yes, I can help you set up your slicer so that it automatically selects the latest available week whenever you click Weekly or Cumulative, without the need to manually update bookmarks every time. I’ll configure the DAX measures and slicer logic so your report dynamically points to the most recent week in your dataset, keeping everything fully automated. This way, your visuals will always stay up to date with no extra maintenance on your end.
₹1,500 INR in 4 days
2.4
2.4

As an experienced Data Analyst and Excel professional, I am perfectly suited for your Invoice Reconciliation project. Over the years, I have honed my skills in meticulously cross-referencing data sets and have developed an eye for accuracy to detect even the most subtle discrepancies. This stems from my background in not only business analysis but also financial management and inventory control, which will allow me to fully understand the nuances of your project. Additionally, my proficiency in various Microsoft tools is an asset that will enable me to create an Excel workbook that's not only clean-cut, but also easy-to-follow and intuitive for your use. I'm comfortable working without traditional accounting software as well, ensuring a seamless workflow throughout the project. To add value beyond the task at hand, I can offer a summary of any inconsistencies found during the reconciliation process along with a clear breakdown of my steps to verify them. I believe these qualities make me an excellent choice for this project and I'm excited to lend my expertise towards ensuring a comprehensive and accurate reconciliation of your invoices. Let's get started!
₹600 INR in 4 days
1.0
1.0

I’m confident I’m a great fit for your project because I focus on creating work that is clean, professional, user-friendly, and seamless—exactly what you’re looking for. I bring hands-on experience in website and WordPress design, branding, presentations, data management, and digital content creation. Over the years, I’ve completed numerous projects for clients outside this platform, consistently delivering work that is reliable, polished, and on schedule. I’d be excited to discuss your project. Regards, Bradley Erasmus
₹750 INR in 14 days
0.0
0.0

Hola ? Soy experto en Excel avanzado y Google Sheets, con experiencia en conexión a bases de datos y manejo de grandes volúmenes de información. Puedo crear una hoja de cálculo sofisticada, con filtros y funciones de ordenamiento robustas, bien estructurada y fácil de usar. Mi propuesta: 4500 INR como precio competitivo (promoción para nuevos clientes en Freelancer). Estoy listo para empezar de inmediato y entregar una solución eficiente..
₹4,500 INR in 2 days
0.0
0.0

As a Full-Stack Developer with Java and React expertise, I am well-equipped to address your need for an online dashboard consolidating multiple Excel files. With robust understanding of data processing and interactive frontend design, I can ensure comprehensive search functionality and filtering options. My proficiency extends into React development – creating dynamic web applications daily. My comprehensive knowledge of Java Spring Boot, REST APIs, and database integration adds value to frontend expertise. This enables me to develop interactive dashboards and craft scalable backend systems for enhanced performance. For your requirements, I can automate data consolidation processes and ensure intuitive search and export functionality. I bring solid experience processing multiple Excel formats and handling complex data transformations, expertly managing complexities in your datasets while assuring consistency. This is an exciting challenge where I can fully apply my expertise to provide a solution perfectly matching your needs. Let's create a seamless data consolidation system!
₹1,050 INR in 3 days
0.0
0.0

Hello, I’m Cristian Yesid González Rodríguez, a BI Consultant and Data Analyst with strong expertise in Power BI, statistical modeling, and report automation. I understand you're looking to enhance your dashboard functionality by automating the selection of weekly data periods. Here’s what I propose: Weekly View Automation Configure the “Weekly” button to automatically select the latest available week from your dataset, without requiring manual updates to bookmarks or slicers. Cumulative View Enhancement Ensure that when the “Cumulative” button is clicked, the end-period slicer dynamically reflects the most recent week available, streamlining user interaction. To achieve this, I’ll apply dynamic DAX measures and parameter-driven filtering techniques that adapt to your data refresh cycle. The solution will be intuitive, scalable, and require minimal maintenance. I’d be happy to assist you with the implementation and ensure your dashboard delivers a seamless user experience. Best regards, Cristian Yesid González Rodríguez BI Consultant | Power BI Specialist Bogotá, Colombia
₹1,800 INR in 7 days
0.0
0.0

Hello, I am a BBA graduate and currently pursuing MBA online at jain university. I have good skills in data entry and MS Excel. I will complete your project accurately and on time. I am ready to start immediately
₹600 INR in 5 days
0.0
0.0

Thank you for the opportunity to work on your project. I've reviewed your requirements and am confident in delivering high-quality results within your timeline and budget. I also bring creative solutions and techniques that can enhance your project's performance and value. As a gesture of goodwill, I'm happy to add ons new feature of your choice at no extra cost. Let's build something exceptional together. Best regards, Muhammad Abdullah Baig
₹1,250 INR in 7 days
0.0
0.0

Use relative and it will work. As per your comments, you need to show relative details only. So you need related rules to be applied Contact to complete the task
₹900 INR in 1 day
0.0
0.0

I’ve gone through your file and requirements, and I’m confident I’m the right fit for this. I specialize in Power BI automation, dynamic slicers, and DAX. I can set up your Weekly and Cumulative buttons so the slicer automatically selects the latest available week without needing manual bookmark updates. You’ll get a seamless, fully automated solution that keeps your reports always up to date.
₹1,050 INR in 7 days
0.0
0.0

With my 3.5 years of experience in the banking and financial services sector, dealing with extensive data analysis tasks such as KYC compliance and due diligence, I have come to appreciate the significance of accessible, real-time data that you require in your Power BI project. Using my strong command over Microsoft Excel, data organization, and reporting automation, I can deliver a solution tailored to your specific needs. My expertise extends to business intelligence reporting and creating visually appealing dashboards, which is essential to your project. I assure you that I can automate the process of updating the slicer based on your weekly data swiftly. With my critical thinking and problem-solving skills, I am confident in finding a robust and adaptable solution that can work for you in the long run. Moreover, my MBA in Financial Management paired with my liking for transforming raw data into meaningful insights aligns well with your project objectives. By selecting me for this job, you not only gain access to technical proficiency in Power BI but also someone with a strong understanding of finance and compliance - positioning me as an ideal fit for this project. Partnering together,I'm confident we can accomplish your vision effectively,accurately and timely.
₹1,500 INR in 3 days
0.0
0.0

FALAKATA, India
Payment method verified
Member since Jan 10, 2022
₹600-1500 INR
$30-250 USD
$30-250 USD
₹600-1500 INR
$250-750 AUD
$10-30 CAD
₹600-1500 INR
$2-8 USD / hour
$750-1500 USD
$250-750 USD
₹600-1500 INR
$5000-10000 USD
$25-50 USD / hour
min $50 USD / hour
₹1250-2500 INR / hour
₹100-400 INR / hour
$15-25 USD / hour
$10-30 AUD
₹750-1250 INR / hour
₹37500-75000 INR
₹37500-75000 INR