Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need some help about using index on a Microsoft Paginated Report. I already applied conditional formatting for the value in line (red if the value is below zero) but I cannot find a solution for the forecast value. I would like to highlight in yellow if the next months next value is below zero.
Here an example:
Apple,Pear or Straberry are yellow on week1 Net column should be yellow because the forecats at end of week 3 is below 0
It currenly loaded as a matrix:
Row: Item Description
Column: Week N.
Values: Sum(Demand),Sum(Supply),Sum(Net)
Thanks in advance for the help.
You can consider to use iff() function , you can refer to the following link.
Solved: Conditional Formatting of Fields in Paginated Repo... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-xinruzhu-msft
Thanks for the hint about lookup, it's a good starting point.
I tried lookup but it's not clear how to use it as in my case I think (but I'm not sure) there's an array implication. In fact I need to lookup week + 3 to retrieve the value for a correct conditional formatting
Thanks
You can refer to the following link.
Solved: Sum Table Column of Lookup values - Paginated Repo... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tried but it doesn't work. I forgot to mention Net column is a measure. I really don't have idea how to achieve it.