Reg-- How to use conditional icon format with week and month wise calculations

[Anonymous]

Hi Everyone,

  I am trying to display icons with conditional format for last month and last week view. I have the period column it contains date of every monday in a month..

I have week and month column in my dataset. I am trying to achieve last week and lst month wise icons to display some conditions like.

same logic is applicable for month also.

kindly help me on this as soon as possible. I attached my sample pbix file for your refrence.

https://1drv.ms/u/s!ApX1j_XZ3zzWg1NP_q8sFdsRiWF0?e=qceywB 

Thanks & regards,

Poornalingam A

[v-yingjl]

Hi @Anonymous ,

Based on your description, not certain what is your expected output. Which column did you want to apply icon conditional format and what is the rule of it?

Could you please combine your sample file, such as Brand A fields, with specific instructions for further discussion?

Best Regards,
Community Support Team _ Yingjie Li

[amitchandak]

@Anonymous , First of all get WOW and MOM using time intelligence.

The create icon using unichar in a measure and same way color measure

MOM

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

WOW

Column

Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format
measures
This Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

Arrow is a measure to display, Color use under conditional formatting using field value option

refer

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
Power BI — Week on Week and WTD
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
https://www.youtube.com/watch?v=pnAesWxYgJ8

Color

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/811692