Hello everyone,
I have a Power BI Paginated Report designed to export only into excel. It has a first table that appears on the first page, and then a second table which repeats, adding further pages for each "Item Type" listed. When exported the excel, these generate as new worksheets within the workbook, with the title of each being the separate Item types.
The problem I am encountering is with the second table, which is separated into the group hierarchy:
1. "Item Type" - this page breaks between each instance of the group to create the separate worksheets.
2. "Item Year"
3."Details"
So the table that appears on each worksheet is separated into Item years, and then the individual items for each Item year.
The table has many columns, but one of these, entitled "Item Address" needs to appear only when the Item Type is "Metallic". Now, I have right clicked on the column for "Item Address", selected column visibility and added the following expression to the "Show or hide based on an expression" box:
=iif(Fields!Item_Type.Value <> "Metallic",True,False)
But when generating the report, the only time this seems to work is if the selected parameter has every Item type as Metallic. If the report has any other Item types present, it always hides the column.
If I set the hide visibility of certain cells using this expression then it hides the cells present in the table where the Item type is Metallic as I'd expect it to.
I would be grateful if someone more experienced than me in report builder could provide some ideas!
