The KPIs I usually work with have national or regional targets that need to be analysed. However, it is still of interest to know how smaller areas are doing with the analysed metric: for these, there should be no target value and KPI should show as grey. We can create a dynamic KPI objective using ISFILTERED: TargetSwitch = IF( ISFILTERED(metrics[Area]), BLANK () ,75]) But the current KPI visual does not eliminate the target, and shows as green. I think this could be quite useful for analysis.
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v18 hours agoCommunity ChampionNew618Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 day agoCommunity ChampionNew21Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 day agoFrequent VisitorNew6Views0likes0Comments