
Closed
Posted
I have a query listing 80 project IDs and the respective time variance vs the previous month. what I need now is the visualization in Power BI that shows in the Y axes the count of of projects that have a variance of 1 month, 2 months etc. I need to insert an slicer to filter the data by division. The variance buckets must stay in monthly intervals; no custom or quarterly groupings are required. Deliverables I expect: • A PBIX file containing the configured bar chart and division slicer • Any DAX measures or transformations you use, clearly labeled • Brief notes (markdown or Word) on where to paste the existing query and how to refresh the model I will consider the job complete when the visual correctly shows project how many projects had a variance of one, two or more months, the slicer filters both the chart and any supporting tables, and everything refreshes without manual fixes.
Project ID: 40502871
78 proposals
Remote project
Active 21 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
78 freelancers are bidding on average $21 CAD/hour for this job

Hi there, I understand you need a Power BI visualization that groups project variances into monthly buckets and displays the count of projects in each variance category, with a division slicer that dynamically filters the results. I am confident I can build a clean, reliable Power BI solution that delivers exactly the analysis you described. My approach will be to import your existing query, create the required variance-bucket logic, and build a bar chart where the X-axis represents variance intervals (1 month, 2 months, 3 months, etc.) and the Y-axis shows the corresponding count of projects. I will configure a division slicer that filters the chart and any supporting visuals in real time. Where needed, I will create clearly labeled DAX measures and Power Query transformations to ensure the model remains easy to understand, maintain, and refresh as new project data becomes available. The deliverable will include a fully configured PBIX file containing the variance distribution chart, division slicer, supporting measures, documented transformations, and concise instructions explaining where to paste the source query and how to refresh the report without manual fixes. Is the variance currently stored as a numeric month value (1, 2, 3, etc.) or as a date difference that needs to be calculated within Power BI? I’m ready to start immediately. Warm Regards, Aneesa.
$15 CAD in 40 days
6.0
6.0

Hi, I can build this by loading your existing query into Power BI, creating a clean monthly variance bucket field, then building a bar chart where the X-axis is variance in months and the Y-axis is the count of project IDs. I will add a division slicer connected to the same model so it filters the chart and any supporting table correctly. Deliverables would include the finished .pbix, clearly labeled DAX/Power Query steps, and short refresh notes showing where to paste or update the query. I will also validate that 1-month, 2-month, 3-month+ variances are counted correctly and that the slicer works without manual adjustments after refresh.
$20 CAD in 40 days
5.2
5.2

Hi, I can help build the Power BI report and configure the visualization exactly as described. I have experience with Power BI, DAX, Power Query, data modeling, and creating interactive dashboards with slicers and dynamic filtering. I'll create a bar chart showing the count of projects by monthly variance bucket (1 month, 2 months, 3 months, etc.), add a division slicer that filters all related visuals, and provide a clean PBIX file with clearly labeled measures and transformation steps. I'll also include brief documentation explaining where to paste the query and how to refresh the model. Best regards, Muhammad Usman
$20 CAD in 40 days
4.7
4.7

AVAILABLE TO START IMMEDIATELY..,,. I will deliver a completed Power BI PBIX file featuring a bar chart showing project counts by monthly variance, an interactive division slicer, documented DAX measures, and step-by-step query integration notes. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$15 CAD in 1 day
4.7
4.7

Hello there, I can build the Power BI visual with monthly variance buckets, project counts on the Y-axis, and a division slicer that filters the chart and supporting tables correctly. I’ll label any DAX/Power Query steps clearly and include short notes showing where to paste your query and how to refresh the PBIX without manual fixes.
$15 CAD in 40 days
3.9
3.9

Hello, I have reviewed your attached data model and I am confident I can deliver exactly what you need in Power BI. With strong experience in Power BI, DAX, SQL, and data modeling, I have built several analytical dashboards involving time variance calculations, bucketed distributions, and interactive slicing. Your requirement is clear: a bar chart showing the count of projects grouped by monthly variance (1 month, 2 months, etc.) with a Division slicer that filters all visuals while maintaining fixed monthly bucket logic. Deliverables: • Fully configured PBIX file with working visuals and slicer • Clearly documented DAX measures and transformations • Short setup notes explaining query placement and refresh steps I will ensure the final dashboard is accurate, refreshable, and meets your validation criteria of correct project counts per variance bucket with fully functional filtering. Looking forward to working with you. Best Regards, Saima Power BI | SQL | Data Modeling | Dashboard Development Specialist
$15 CAD in 40 days
3.9
3.9

Hi, This is a straightforward Power BI task and I can deliver it quickly. I will create a PBIX file that transforms your variance data into a clear distribution chart showing the count of projects by variance month (1 month, 2 months, 3 months, etc.) while maintaining monthly intervals exactly as requested. Deliverables: • Power BI (.pbix) file with the configured bar chart • Division slicer that filters all visuals and supporting tables • Clearly labeled DAX measures and transformations • Documentation showing where to paste your query and how to refresh the model • Validation to ensure the chart correctly counts projects within each variance bucket My approach focuses on keeping the model simple, dynamic, and easy to maintain so future data refreshes require no manual fixes. I have experience building Power BI dashboards, DAX measures, Power Query transformations, and interactive filtering solutions, and I can start immediately once you share the query structure. Best regards, Ateeb Rahil Mahedvi
$20 CAD in 20 days
3.2
3.2

Hi I understand you need a Power BI visualization that counts projects by monthly variance buckets, with a division slicer filtering the chart and supporting tables. I have experience with Power BI, DAX measures, Power Query transformations, SQL query integration, slicers, bar charts, data modeling, and refresh-ready PBIX setup. The main technical challenge is making sure the variance values stay grouped by exact monthly intervals while the project count responds correctly to the division filter. My solution would be to load your existing query into Power BI, create a clean variance bucket field or DAX measure, and configure a bar chart with project count on the Y-axis and month variance on the X-axis. I can also add the division slicer and verify that it filters the chart and any supporting table consistently. All DAX measures or Power Query steps would be clearly labeled so the logic is easy to understand and maintain. I would include brief notes showing where to paste the query, how to refresh the model, and how the variance bucket logic works. Overall, I can deliver a clean PBIX file that accurately shows how many projects fall into each monthly variance bucket. Thanks, Hercules
$100 CAD in 40 days
3.3
3.3

hi i have a lot of experience in power bi,vba etc with advance level of data analysis.i can help you in all such projects with attractive dashboard creation and visualization.i will provide my previous works as a sample.
$20 CAD in 40 days
3.2
3.2

Hello, I can help you build this Power BI report quickly and cleanly. Based on your requirements, I will create: • A bar chart showing the count of projects by monthly variance bucket (1 month, 2 months, 3 months, etc.). • A Division slicer that dynamically filters the chart and any supporting visuals. • Required Power Query transformations and DAX measures with clear naming conventions. • A fully functional PBIX file that refreshes automatically when the source query is updated. • Simple documentation explaining where to paste/update the query and how to refresh the model. I have experience developing Power BI dashboards involving project tracking, KPI reporting, variance analysis, and interactive filtering. I'll ensure the variance buckets remain in monthly intervals and that the visualization accurately reflects the number of projects in each variance category. Deliverables: ✓ PBIX file ✓ DAX measures and transformations documented ✓ Refresh/setup instructions ✓ Tested filtering behavior for Division slicer If you can share the query structure or sample dataset, I can review it immediately and provide a solution with a fast turnaround. Best regards, Jemin Sagar
$25 CAD in 40 days
3.5
3.5

Could you confirm whether the variance field in your query is already stored as a numeric value (e.g., 1, 2, 3, -1, -2) or whether it is currently represented as text such as "1 month", "2 months", etc.? I understand you have a dataset containing approximately 80 project IDs and their month-over-month time variance, and you need a Power BI visualization that groups projects by variance intervals and displays the project count for each bucket. My approach would be to import your query into Power BI, validate the variance field, create any required DAX measures or calculated columns, and configure a bar chart where the X-axis represents variance buckets (1 month, 2 months, 3 months, etc.) and the Y-axis displays the corresponding project count. A Division slicer would be connected to the model so that both the chart and any supporting visuals respond dynamically to user selections. The final PBIX would be structured cleanly with documented measures and a straightforward refresh process.
$25 CAD in 5 days
2.6
2.6

IF YOU'RE NOT HAPPY, DON'T PAY. I understand that you already have a query containing project IDs and their monthly variance values. You need a Power BI visualization that groups projects by variance buckets (1 month, 2 months, 3 months, etc.), displays the count of projects in each bucket, and allows filtering by division using a slicer. I can build this quickly and deliver a clean, fully functional PBIX file with: ✓ Bar chart showing project counts by monthly variance bucket ✓ Division slicer that filters all visuals and supporting tables ✓ Clearly documented DAX measures and transformations ✓ Proper data model setup for easy maintenance ✓ Refresh-ready solution with no manual fixes required ✓ Brief documentation explaining where to paste your query and how to refresh the report With my experience in Power BI, DAX, Power Query, and dashboard development, I can ensure the visualization accurately reflects the variance distribution and remains scalable if additional projects are added later. To get started, I'll need: • Your existing query or sample dataset • The division field used for filtering • Any preferred formatting or branding requirements I can begin immediately and expect to complete the dashboard within a few hours of receiving the data. Looking forward to helping you deliver this report. Best regards, Noreen Sajjad Power BI Developer | Data Analyst
$15 CAD in 40 days
1.9
1.9

Hi there, I’d love to help your remote team make sense of your data. I specialize in taking raw, fragmented datasets and turning them into clean, automated, and visually striking Power BI dashboards and Excel models. I know how frustrating it can be when data is scattered across different files—my goal is to take that off your plate entirely so you can focus on making actual, data-driven decisions without the headache. Why I’m a great fit for this: End-to-End Execution: I handle everything from data cleansing (de-duplication, string standardization) and relational data modeling (Star Schema) to building out the final DAX measures and interactive dashboards. Remote-First Workflow: I’m highly focused on async communication and building automated reporting suites that work perfectly for distributed teams. Proven Experience: I recently built a Global Automobile Sales BI Ecosystem from scratch, managing the entire ETL process (Power Query) and Power Pivot modeling to deliver clean, actionable insights. Most projects like this take me anywhere from 1 to 4 weeks depending on the data complexity, meaning you'll have a sleek, automated reporting solution up and running very soon. Best regards, Nadeera
$15 CAD in 25 days
2.0
2.0

Hello, I can help you build the histogram/chart and add the slicer. I am a Microsoft Certified Power BI Analyst with extensive experience in data modeling, DAX measures, data visualization and creating comprehensive reports and dashboard, and I can deliver the results you need in the best way possible. Please feel free to contact me to discuss your project in more detail. Thanks a lot. Best regards, Emilia
$20 CAD in 20 days
1.6
1.6

- I have hands-on experience building Power BI dashboards, interactive visuals, and DAX-based reporting solutions. - I can create the required bar chart showing the count of projects by monthly variance buckets (1 month, 2 months, 3 months, etc.) while preserving the monthly interval structure. - I will configure a division slicer that filters the chart and any supporting visuals or tables consistently across the report. - My experience includes Power BI data modeling, DAX calculations, KPI reporting, and automated refresh workflows. - In a recent project, I developed a PHP API, integrated database data into Power BI, and created automated real-time dashboards for business reporting. - I will provide a clean PBIX file, clearly labeled DAX measures and transformations, and concise instructions on how to paste the query and refresh the model. - The final solution will be easy to maintain and refresh without manual fixes. Reference work is available in my profile.
$20 CAD in 40 days
1.0
1.0

Hello, I can help create the Power BI visualization showing the count of projects by monthly variance buckets, with a division slicer filtering the chart and any supporting tables. I have experience with Power BI, data visualization, DAX, data transformations, and clean reporting workflows. I’ll set up the model from your existing query, create clearly labeled monthly variance buckets like 1 month, 2 months, 3 months, and more as needed, then build a bar chart with project count on the Y-axis and variance month bucket on the X-axis. I’ll deliver the PBIX file setup, labeled DAX or Power Query steps, and short refresh notes showing where to paste your query. I am ready to start. Best regards, Smit
$20 CAD in 40 days
0.6
0.6

Dear Client, I am a Data Analyst and Power BI Developer with experience in transforming raw data into actionable business insights. I can help you design and develop interactive dashboards, build efficient data models, create DAX measures, and deliver clear visualizations that support data-driven decision-making. For this project, I will thoroughly analyze your requirements, ensure data accuracy, develop scalable reporting solutions, and provide a user-friendly dashboard tailored to your business objectives. My approach focuses on delivering reliable insights, performance optimization, and meaningful KPI tracking to help stakeholders make informed decisions. The estimated delivery timeline is 4 days, with 5 hours dedicated per day to ensure quality development, testing, and refinement. My rate is $20 per hour. I look forward to contributing to the success of your project and delivering a solution that exceeds expectations. Best regards, Chijioke Chidiebere
$20 CAD in 20 days
0.6
0.6

Hello, As a result of a detailed review of your project requirements, I understand you need a clean Power BI report that visualizes project time variance distribution with proper monthly bucketing and a division-based slicer. I bring solid experience in Power BI, Data Visualization, DAX measures, and data modeling, with a focus on building clear, business-ready dashboards from raw query outputs. One of the key challenges in this type of work is correctly normalizing the variance values into strict monthly buckets and ensuring the slicer filters both the visual and underlying model without breaking aggregation logic. My approach is to structure your dataset inside Power BI, create a calculated column or DAX measure for monthly variance grouping (1 month, 2 months, etc.), and build a bar chart showing project counts per bucket. I will also implement a division slicer that correctly filters all visuals and ensure the model refreshes cleanly with your existing query. I have a couple of quick questions. • Is your current dataset already loaded into Power BI as a query, or will I need to connect it from Excel/SQL source? • Do you want the variance calculated as absolute difference or signed (positive/negative) values? I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos.
$15 CAD in 40 days
0.0
0.0

As an experienced software developer with a specific expertise in data visualization, I am confident that I possess the required skill set necessary to successfully complete your project. I have more than two decades of hands-on experience in developing powerful web platforms and mobile applications for diverse purposes, including sports analytics – which aligns perfectly with your need for clear Time Variance visualizations. My profound understanding of the Power BI tool and my ability to develop elegant DAX measures to transform raw data into meaningful insights make me an ideal candidate for your job. Moreover, my commitment to providing comprehensive deliverables by producing organized PBIX files, labeled DAX measures, and detailed notes, ensures not only the successful completion of the project but also enhances its future maintenance. With continuous communication and a collaborative approach, I will work diligently to create a visualization solution that meets your exact specifications. Ensuring that the variance buckets remain in monthly intervals and implementing a slicer for division filtering is well within my capabilities. Let's partner together to convert your data into actionable insights using the power of Power BI!
$25 CAD in 40 days
0.0
0.0

Greetings, I see you're looking to visualize the time variance of your 80 project IDs in Power BI, specifically focusing on how many projects fall into each monthly variance bucket. This is a great way to track performance over time and make informed decisions. To tackle this, I’d create a bar chart that displays the count of projects based on their variance from the previous month, while implementing a slicer for division filtering. This will let you easily analyze and compare data across different segments without any custom groupings. I'll ensure that all DAX measures and transformations are clearly labeled in the PBIX file, along with straightforward instructions for refreshing the model. With my experience in data visualization and Power BI, I can help you achieve a clean, functional design that meets your needs.
$20 CAD in 7 days
0.0
0.0

Toronto, Canada
Payment method verified
Member since Feb 12, 2015
$15-25 CAD / hour
$15-25 CAD / hour
$15-25 CAD / hour
$30-250 CAD
₹600-1500 INR
₹100-400 INR / hour
$250-750 USD
$30-250 USD
₹12500-37500 INR
$250-750 USD
₹37500-75000 INR
₹1500-12500 INR
₹600-1500 INR
₹100-400 INR / hour
₹12500-37500 INR
₹1250-2500 INR / hour
₹12500-37500 INR
$15-25 USD / hour
₹750-1250 INR / hour
$10-30 USD
€1500-3000 EUR
₹1500-12500 INR
$100-200 USD
₹600-1500 INR