Forum Discussion
Post ProdigyComparison Icon for Trend wow(week over week)
Hello All,
Please note, a trend icon created to comparing current with previous week, below column highlighted in Red is in % format.
Decimals is considering automatically for WoW(Week over Week) trend
Current week it is 48.37% & Previous week it is 47.62% , in format if i consider 0 decimal it is rounding off to 48%, regarding comparison for current week trend it is showing UP "▲" arrow, but it was suppose to be Equal "--"
Measure used:
Thanks for you Support.
Regards,
2 Replies
- amitchandak
Super User
harirao , Not very clear.
You can Try like
WOWTrend2 = IF(Round([test_Wow2],0)<0,"▼",IF(round([test_Wow2],0)>0,"▲","--"))
In case you have issue with WOW then refer to my blog
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
hariraoHello amitchandak ,
Thanks for your quick response, I am looking for solution were current week & previous week percentage value is same. Icon should be Equal "--", due to decimal it is taking UP & DOWN arrows.
By using above blogs/links only i was able to create week over week trend.
Note, after using the measure all trend is showing equal "--"Thank you
