Forum Discussion
Aggregated KPI
Hi Anonymous ,
Please check whether the custom visual KPI Indicator is what you want. If no, please provide some sample data and more details about your requirement. Thank you.
Use of Key Performance Indicators in Power BI
Best Regards
Hi @yingyinr,
Close, but not exactly, I've tried using the indicator visual but cannot use the total aggregation type if that makes sense. So with the data I've provided here as an example, I'd like to see the P90 value over time, broken up into months, which can be easily done with the KPI Indicator (Dec 2020=192, Jan 2021=410, Feb 2021=195). But with the data I've provided, I would also like to see the total P90 in the highlighted area of the visual if that makes sense. So I'd like to see 260 in the summarized area of the visual, since that's the 90th percentile of the entire dataset. Thanks in advance!
| Month | Value |
| Dec-20 | 150 |
| Dec-20 | 160 |
| Dec-20 | 200 |
| Jan-21 | 10 |
| Jan-21 | 180 |
| Jan-21 | 200 |
| Jan-21 | 500 |
| Feb-21 | 150 |
| Feb-21 | 200 |