Forum Discussion

t_patts's avatar
t_patts
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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's avatar
    AlexisOlson
    4 years ago

    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] ) )
)
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

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