Hello team i am facing issues with power kpi custom visual trend lines are showing blank in power bi desktop and working in power bi service.
Power bi kpi visual shows blank.
The visual works correct for the end date upto 31st december 2016.
These visuals can be created and viewed in both power bi desktop and the power bi service.
I have two measures.
Download sample power bi file.
Hi i am working on a dashboard in which i am trying to implement a kpi visual for current period vs previous period values.
Returning a value instead of blank means that in a visual with an axis table matrix column bar charts etc if for a combination there is no data still the visual will show that with zero as a result.
It works great when there are items matching but if nothing matches it shows blank.
I have come across a strange behaviour of the kpi visual that i seem not be able to solve.
Here is an example.
If you would like to follow along closely download or connect with the sample before getting started.
I know this is a common problem and that people solve it by either doing the following.
A good way to visualize this scenario is to add the kpi measure and goal to a table with the same filters as the kpi visual.
The steps and illustrations in this article are from power bi desktop.
I ve got a card visual which is just showing a count of how many items match my filter.
One of them calculates some percentage the other one just uses a simple formular to calculate a fixed target.
The kpi measure will display blank when it evaluates to blank and the kpi goal is not blank.
My dashboard showed blank as the value in a card visualization when i really wanted to see 0.
But when i change my end date to any date from january 2017 kpi visual starts me showing goal as blank and.
Download the sample power bi report here.
To start click the kpi icon on the visualizations pane.
It s now time to fill the visual with information.
If it can t find any occurrences it returns blank resulting in the kpi picture at the top.
Is there a best practice to deal with this or a simple way to adjust this.
Kasper langmann co founder of spreadsheeto.
How can i make it show 0 instead please.
This does not seem to be a data type issue.
Here is my current solution.
Value 0 97 0 97.
A key performance indicator kpi is a visual cue that communicates the amount of progress made toward a measurable goal.
The measure that is being displayed in the kpi is a monthly average of several of the distinctcount measures displayed on the right.