Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
M_nwadibia
Resolver III
Resolver III

Rollup Using SSRS Expression and make a row bold

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.

 

M_nwadibia_0-1673044851583.png

 

3 REPLIES 3
Medina
Helper II
Helper II

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,

Medina_0-1674853046977.png

To produce the output shown above, you need to:

  1. Create a blank report
  2. Create a data source, select "Enter Data" as your Connection Type, and click OK
    Medina_1-1674853464732.png

     

  3. Create a Datasets, use the Data Source --> Query Type (Text) created in Step 2. Use the following, XML as the source

 

<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>​

 

  • Add the table to the report
    Medina_2-1674853705345.png

     




  • Right-click on the detail row [Company] and select Text Box property
    Medina_4-1674853839703.png

     

  • Click the Fill option and enter the following expression
    =IIF(Fields!Company.Value="Total","LightSteelBlue","Transparent")
  • Repeat Step 6 for the other columns

I hope it helps. Unfortunately, the forum does not allow me to upload the rdl or any other file format.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors