This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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!!
Solved! Go to Solution.
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
Logic for wow is as follows
Hi @Kpiuser ,
Sharing below the measures that I created for this purpose.
wow = [curr_week_value] - [prev_week_value]
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
Logic for wow is as follows
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.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 26 | |
| 25 | |
| 24 | |
| 21 | |
| 14 |
| User | Count |
|---|---|
| 53 | |
| 47 | |
| 23 | |
| 18 | |
| 18 |