Forum Discussion
Up and Down Arrows in KPI
I want to implement up and down arrows based on last two columns of this matrix. But I got arrows for all the columns. Can anybody help with this.
My dax codes:
1.
- Anonymous3 years ago
Hi mosam ,
Sorry, that was a spelling error on my part.
Update the measure.
Indicator = var _date1=MAXX(FILTER(ALL('Galle_Base'),'Galle_Base'[Site Name]=MAX('Galle_Base'[Site Name])),[Date]) var _date2=_date1-1 return SWITCH( TRUE(), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date1, UNICHAR(9650), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date2, UNICHAR(9650), BLANK())Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- amitchandak
Super User
mosam , You can use icon conditional formatting
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50
For MOM
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s - AnonymousNot applicable
Hi mosam ,
According to your description, here are my steps you can follow as a solution.
(1) We can update the measure.
Indicator = var _date1=MAXX(FILTER(ALL('Galle_Base'),'Galle_Base'[StartName]=MAX('Galle_Base'[StartName])),[Date]) var _date2=_date1-1 return SWITCH( TRUE(), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date1, UNICHAR(9650), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date2, UNICHAR(9650), BLANK())(2) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mosamFrequent Visitor
What is StartName here?
- AnonymousNot applicable
Hi mosam ,
Sorry, that was a spelling error on my part.
Update the measure.
Indicator = var _date1=MAXX(FILTER(ALL('Galle_Base'),'Galle_Base'[Site Name]=MAX('Galle_Base'[Site Name])),[Date]) var _date2=_date1-1 return SWITCH( TRUE(), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date1, UNICHAR(9650), [CurrentMonthCount] > [PreviousMonthCount] && SELECTEDVALUE('Galle_Base'[Date])=_date2, UNICHAR(9650), BLANK())Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.