search

okviz / free-visuals

Power BI free custom visuals
MIT License
24 stars 7 forks source link

Cards with states - Average value with trendline on date does not provide the expected result #299

Closed Markwijnholds closed 1 year ago

Markwijnholds commented 2 years ago

Describe the issue When using the Cards with states visual with a value (e.g. score from evaluations) as input in the measure and a date (moment of evaluation) in the trendline, I would expect the average value of all scores in the relevant period as the output. However I am not able to get this result from the visual. The problem exists when there is more than one input value (score) in the same date. Instead of taking each input as a seperate value it instead sums these values in the same date, and then takes the average of the sum of score of each date. However, what I want is the actual average.

test.zip In the example file there are 2 scores on 08-01-2021, so the average on that date should be 6.5, and count twice (2 input values) for the total average.

The total average should be 5.4. Any help would be greatly appreciated.

Version Power BI Desktop: 2.98.1025.0 (november/2021)

riccard0russ0 commented 1 year ago

We have temporarily suspended the development of new features and addressing bugs that aren't related to security. This decision is based on the fact that the new Power BI built-in Cards supports almost all Card with States functionalities. We will reconsider this decision if our plans change.