Forum Discussion
Matrix Table One extra column for icon
This is my current matrix table. The info within is confidential, so I need to blur, but needed to show what I'm trying to accomplish.
Rows: Facility
Columns: Week Ending Date
Values: Potential Savings
I'm going to explain this in a couple different ways to make sure I'm getting across what is in my head. lol.
I'm wanting to add one more column at the end. With icons to show up or down arrows, indicating whether or not the number went up or down. Only between the last two values.
Another way of saying it: I need 5 weeks to show, but I want a 6th column at the end that compares the 5th week to the 4th week, and displays an arrow up or down depending.
Is this even possible?
Hi FECStevenL ,
Please have a try.
Create a measure.
Trend Indicator = VAR CurrentWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date])) VAR PreviousWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]) - 7) RETURN IF(CurrentWeekValue > PreviousWeekValue, "Up", IF(CurrentWeekValue < PreviousWeekValue, "Down", "Same"))How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi FECStevenL ,
Please have a try.
Create a measure.
Trend Indicator = VAR CurrentWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date])) VAR PreviousWeekValue = CALCULATE(SUM('Table'[Potential Savings]), 'Table'[Week Ending Date] = MAX('Table'[Week Ending Date]) - 7) RETURN IF(CurrentWeekValue > PreviousWeekValue, "Up", IF(CurrentWeekValue < PreviousWeekValue, "Down", "Same"))How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.