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
- Anonymous5 years agoNot applicable
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