Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Kpiuser
New Member

Increase, decrease Icon week on week

Hi guys - I have a Matrux table below Date in column field that is counting all the number of clients by status over the weekly periods.
I would like to  add an Arrow Green and Red icons to Indicate if the number increases or decreases. Could you please help how do I do it? Do i need to create a measure first? it's not allowing me to do it in the conditional formatting. Thank you in advance!!

 

Kpiuser_0-1667533411565.png

 

1 ACCEPTED SOLUTION
Thejeswar
Super User
Super User

Hi @Kpiuser ,

Have a measure created that will return the WOW Number difference. Use this measure to set up the conditional formatting for the week values measure like shown below

 

Thejeswar_1-1667541644841.png

Logic for wow is as follows

wow = [curr_week_value] - [prev_week_value]

 

 

Thejeswar_0-1667541581611.png

 

 

View solution in original post

3 REPLIES 3
Thejeswar
Super User
Super User

Hi @Kpiuser ,

Sharing below the measures that I created for this purpose. 

wow = [curr_week_value] - [prev_week_value]

curr_week_value = sum('Table'[Value])
prev_week_value = CALCULATE(SUMX('Table', 'Table'[Value]), 'Table'[Week] = MAX('Table'[Week])-1)
 
Attached the PBI file for your reference
Thejeswar
Super User
Super User

Hi @Kpiuser ,

Have a measure created that will return the WOW Number difference. Use this measure to set up the conditional formatting for the week values measure like shown below

 

Thejeswar_1-1667541644841.png

Logic for wow is as follows

wow = [curr_week_value] - [prev_week_value]

 

 

Thejeswar_0-1667541581611.png

 

 

Hello Thesjeswar, Thank you so much for the idea. It's really helpful. However, could you please teach me how did you structure the week on week dax measure? I totally got the logic but my measure is not showing the correct result. 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors