Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
t_patts
Frequent Visitor

Modeling Changes to Pi Chart Over Time

How can I model the changes to a Pi chart over time?

Some context: I have a report for the amount of items that are late broken out by their level of lateness in Pi chart form.

My client has asked I show the changes to this report from week to week.

What would be the best way to do this? Line and stacked column chart?

Will I need to have seperate excel documents/sheets for each week and pull all of them in?

Can I have Power BI track the deltas?

2 ACCEPTED SOLUTIONS
AlexisOlson
Super User
Super User

A stacked area or stacked bar chart are decent options to visualize this sort of thing.

 

Here are examples of what they might look like:

AlexisOlson_0-1647551006210.png

 

AlexisOlson_1-1647551037162.png

View solution in original post

Yes, this is possible. You just need to write a measure to take the proportion over the appropriate granularity. For example, the measure for your bars might be

Proportion =
DIVIDE (
    COUNTROWS ( Table1 ),
    CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1[Late Level] ) )
)

and the line measure

Late% =
DIVIDE (
    CALCULATE ( COUNTROWS ( Table1 ), Table1[Late Level] <> "On Time" ),
    CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1[Late Level] ) )
)

View solution in original post

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi, @t_patts 

Power BI can't save historical data and track deltas.

You need to manually pull the weekly data for comparison and you can consider using the folder connector to access these pre-prepared data.

As mentioned by @AlexisOlson ,area charts can be good choice to visualize this.

 

Best Regards,
Community Support Team _ Eason

AlexisOlson
Super User
Super User

A stacked area or stacked bar chart are decent options to visualize this sort of thing.

 

Here are examples of what they might look like:

AlexisOlson_0-1647551006210.png

 

AlexisOlson_1-1647551037162.png

https://drive.google.com/drive/folders/16oFJXo9iPINyP2KlOJlgcVRfXoxmi8MX?usp=sharing

^^^ Here is my scrubbed data. I have Power BI "Get Data" ing by pulling in the folder and then summarizing the top 10 descending rows (so data is added automatically when a new data file is added).

 

Here is what it looks like:

t_patts_0-1648651222887.png

 

Here are my current parameters for the line and stacked column chart:

t_patts_0-1648590985403.png 

 

The proportion by week is renamed but its the % GT of count for equipment description of the aggregate files.

 

I know the selection method (summarize and combine) is the reason the total weekly percent is not 100, its X% of all of the items in all of the files being combined and summarized.. I would like to have it look like your second graph where each week has 100% of each weeks items (seperate from other weeks), not X% of total items from both weeks spreadsheet.

 

Can I do this while still pulling in new files each week automatically or will I have to manually pull the files to keep the items seperate? What can I do to get each week as its own set?

 

 

Yes, this is possible. You just need to write a measure to take the proportion over the appropriate granularity. For example, the measure for your bars might be

Proportion =
DIVIDE (
    COUNTROWS ( Table1 ),
    CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1[Late Level] ) )
)

and the line measure

Late% =
DIVIDE (
    CALCULATE ( COUNTROWS ( Table1 ), Table1[Late Level] <> "On Time" ),
    CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1[Late Level] ) )
)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors