Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have come across a strange behaviour of the KPI-Visual that I seem not be able to solve:
I Have two measures. One of them calculates some percentage the other one just uses a simple formular to "calculate a fixed target":
value 0.97 = 0,97
I want to use these two Measures in a KPI Visual but get Blank as result. The interesting thing is, that if I switch aroung "indicator" and "target goal" I get a number. But of course the number is wrong for my purpose.
Also when I just add the indicator without the target I get a number back. Only when I combine the two fields in one certain way I get Blank.
I have no clue what causes this behaviour. I would at least have expected that it shows BLANK in both cases. Here is a picture that explains the problem:
Thanks in advance for your help.
BR,
Torben
Solved! Go to Solution.
Hi @Anonymous ,
Please refer to the following example:
Assume that I have a table like below:
Then I create a measure as the target like below:
value = 205
Then drag these columns to the related field, the result like below:
Best Regards,
Teige
Have you solved the problem? I am facing the same issue.
Hello. I am having the same problem.
I know why it is happening although I havent been able find a way around the issue.
I created two measures: 1) A measure I want to track using KPI and 2) A "fixed" measure that indicates the treshold for my KPI goal (e.g: 10).
When I create my KPI I want it to have a trend axis (date hierarchy by months).
So basically the problem is that my first measure (the one I am looking to track) comes from a table that is up to the maxcurrentdate, while the second measure (the fixed goal) comes from a table that is populated for the entire year (see picture). So logically the KPI will analyze the last given month, which has a Fixed Goal but has no value for the measure that I want to track, hence I get the BLANK result.
How do I set my Goal Measure to only provide values for current or past months?
Thanks
Hi @Anonymous ,
Please refer to the following example:
Assume that I have a table like below:
Then I create a measure as the target like below:
value = 205
Then drag these columns to the related field, the result like below:
Best Regards,
Teige
In the example specified, I want to have a dynamic goal i.e median(column1). How can I specify goal here?
If I create a calculated measure for the median to fix this, it is rendering blank.
Thanks in advance,
Veda
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |