Challenge with Displaying Planned and Physical Progress Percentages in Power BI Bar Chart

[Naserkordian]

Hello everyone,

I am working with Power BI on a project that includes 9 different categories. For each category, I have calculated the planned and physical progress percentages. However, when I try to display this data in a bar chart, I encounter an issue.

For each category, I have two measures for planned and physical progress, which results in a total of 18 measures (9 categories × 2 progress values). The problem is that in the bar chart, instead of displaying only two bars per category (one for planned progress and one for physical progress), it displays 18 different bars, which makes the chart cluttered and difficult to read.

My question is how can I display only the two progress values (planned and physical) for each category in the bar chart and avoid showing all 18 bars?

Thank you in advance for your help and guidance.

[Ashish_Mathur]

Hi,

Consider using the "Unpivot Other Columns" feature of Power Query.

[Naserkordian]

Issue with Project Progress Calculation and Visualization in Power BI

Hello everyone,

I’m facing a challenge while calculating and visualizing project progress for 9 different categories in a scheduling file containing approximately 2,300 records.

What I’ve Done So Far:

1. Created Custom Categories:
   I added a new column in my source scheduling file to categorize the records into 9 groups, as these categories were not originally part of the dataset:
• Structure
• Masonry
• Mechanical and Electrical Installations (Phase 1)
• Building Activities (Phase 1)
• Building Activities (Finishing and Installations - Phase 2)
• Mechanical and Electrical Installations (Finishing and Installations - Phase 2)
• Staircase Activities
• Hallway Activities
• Finishing and Cleaning
2. Calculated Weighted Progress for Each Category:
   Using the total weights of the project and progress percentages (planned and physical), I calculated measures for each category.

For example, for the Structure category:

• Total Progress (Planned):

DAX

Copy code

TotalProgress_Structure_Plan =

CALCULATE(

    SUM('Schedule'[ProgressWithWeightPlan]),

    'Schedule'[Category] = "Structure"

)

• Total Progress (Physical):

DAX

Copy code

TotalProgress_Structure_Physical =

CALCULATE(

    SUM('Schedule'[ProgressWithWeightPhysical]),

    'Schedule'[Category] = "Structure"

)

• Final Progress (Planned):

DAX

Copy code

FinalProgress_Structure_Plan =

DIVIDE(

    [TotalProgress_Structure_Plan],

    CALCULATE(SUM('Schedule'[Weight]), 'Schedule'[Category] = "Structure")

)

• Final Progress (Physical):

DAX

Copy code

FinalProgress_Structure_Physical =

DIVIDE(

    [TotalProgress_Structure_Physical],

    CALCULATE(SUM('Schedule'[Weight]), 'Schedule'[Category] = "Structure")

)

I repeated this for all 9 categories, resulting in 18 measures (9 for planned progress and 9 for physical progress).

The Problem:

When I try to visualize this in a bar chart, I now have 18 measures instead of just 2 (one for planned progress and one for physical progress). This makes it very difficult to present the data in a simple and clean way.

The Help I Need:

• How can I consolidate these 18 measures into just 2 measures (one for planned progress and one for physical progress) while maintaining the breakdown by category?
• Alternatively, how can I effectively visualize these 18 measures in a single bar chart?

Apologies for the lengthy explanation, but I wanted to make the issue clear. I really appreciate any advice or guidance from the community.

Thank you in advance for your help!

[v-zhangtin-msft]

Hi, @Naserkordian 

As your question is complex, could you provide example files? Please remove any sensitive data in advance.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[Naserkordian]

[Jai-Rathinavel]

Hi @Naserkordian , You can use on of the below two charts,

1. Clustered column chart: Pull in your two measures with Category as your X axis

2. Stacked Column Chart: Displays one single bar for each category

Thanks,

Jai

[Jai-Rathinavel]

Hi @Naserkordian , You can use on of the below two charts,

1. Clustered column chart: Pull in your two measures with Category as your X axis

2. Stacked Column Chart: Displays one single bar for each category

Thanks,

Jai