Paginate Report lookup

[UKNSI-Powerbi]

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.

[v-xinruzhu-msft]

Hi @UKNSI-Powerbi 

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

Lookup function in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microso...

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.

[UKNSI-Powerbi]

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

[v-xinruzhu-msft]

Hi @UKNSI-Powerbi 

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.

[UKNSI-Powerbi]

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.