Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a requirement to make the total row bold but when I try this expression it makes the entire field bold.
=IIf(Fields!Submitted_Surveys_with_LMI.Value="Total","Bold","Default"). I want only the Row Total bold. If this cannot work how can I write an expression for RollUP for each field to get the total so that I can have control over fields.
Hi,
Reading the expression, made me think the "TOTAL" is part of the recordset, if that is the case, I would apply the formatting condition on each column.
Please, let me know if I am not reading your question correctly.
Thanks!
Yes I only want the last row made bold.
Hi,
To produce the output shown above, you need to:
<Query>
<XmlData>
<Data>
<Row>
<Company>ACME USA</Company>
<Total_A>100</Total_A>
<Total_B>50</Total_B>
<RowOrder>0</RowOrder>
</Row>
<Row>
<Company>ACME Canada</Company>
<Total_A>100</Total_A>
<Total_B>40</Total_B>
<RowOrder>1</RowOrder>
</Row>
<Row>
<Company>ACME Mexico</Company>
<Total_A>40</Total_A>
<Total_B>100</Total_B>
<RowOrder>2</RowOrder>
</Row>
<Row>
<Company>Total</Company>
<Total_A>240</Total_A>
<Total_B>190</Total_B>
<RowOrder>3</RowOrder>
</Row>
</Data>
</XmlData>
<ElementPath>Data{}/Row{Company(String),Total_A(Float),Total_B(Float),RowOrder(Float)}</ElementPath>
</Query>
I hope it helps. Unfortunately, the forum does not allow me to upload the rdl or any other file format.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.