Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.