Forum Discussion
Top 1 visual filter shows different results with Integer/String
Hi, I have a column called Year. Data exists from 2004-2018. Initially it was a number. However, when I used this to filter in a Top 1 visual filter it showed the values for 2017. When I switched it into a text field, it shows the values for 2018. Now I do have a solution but still do not understand why. Also with a number I expected to get the 2018 values. Want to understand this.
Thx
BR Christian
Perhaps I need to add the I want to show the revenue (which is another column) on a card always for the actual year. Instead of creating a new measure.
4 Replies
- LivioLanzoSolution Sage
Hi _chris_, could you share your file?
- v-cherch-msftMicrosoft Employee
Hi _chris_
I cannot reproduce the same issue as you said. Could you share more about your data sample?
Regards,
Cherie
- _chris_Helper III
Sorry for bothering you. I could not reproduce the issue. BR Chris
- v-cherch-msftMicrosoft Employee