Forum Discussion
KPI Visual with slicer
Hi scottda4270 ,
This is currently not possible, as the trendline needs two dates to show the future trend direction, so if you filter a piece of data, it will locate the corresponding date, causing the trendline to disappear.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi scottda4270 ,
The following link will help you:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
It requires at least three components:
- Value: The main measure you want to evaluate, which could be sales, expenses, etc.
- Target: What you want to compare the value with. This can be another measure or a static goal.
- Trend: Shows how the value performs over time.
The value is shown on the foreground as an indicator of where you stand right now.
The target provides a reference point that indicates whether your value is meeting expectations (above, below, or on target).
The trend shows the direction and pattern of change over time.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi scottda4270 ,
This is currently not possible, as the trendline needs two dates to show the future trend direction, so if you filter a piece of data, it will locate the corresponding date, causing the trendline to disappear.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous , so how is the KPI visual meant to work then? how does it know what measure to show if you have a list of values...cleary the trend will show in the background but what logic does it use to show the foreground measure? thanks
Hi scottda4270 ,
The following link will help you:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
It requires at least three components:
- Value: The main measure you want to evaluate, which could be sales, expenses, etc.
- Target: What you want to compare the value with. This can be another measure or a static goal.
- Trend: Shows how the value performs over time.
The value is shown on the foreground as an indicator of where you stand right now.
The target provides a reference point that indicates whether your value is meeting expectations (above, below, or on target).
The trend shows the direction and pattern of change over time.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
