Suppress/Hide Dataset fields that are not in a table/matrix/chart, if they are null
Hello! I am really new to Power BI Report Builder so I am still learning my way around. I am building a report for our tenant's leases (Lease Abstract). All of the data is imported from a SQL server and this particular DataSet is called DataSet1. I am trying to hide these below fields IF they are Null values. I do not want to change the query to exlude results that have null values in these columns (WHERE statement). So, for example, in this particular lease abstract amendments 2-10 have null values but amendment 1 does not: Is there any way to hide amendment 2-10? I have tried using the textbox properties and used "Show or hide based on an expression". I have tried [=IIF(IsNothing(First(Fields!Amendment_1.Value, "DataSet1")))] [=IIF(First(Fields!Amendment_1.Vlaue, "DataSet1") = NULL, true, false)] [as well as false, true] [=IIF(Fields!Amendment_1.Value = NULL, true, false)] [as well as false, true} All of these return a series of errors such as "Overlaod resultion falied becuase no accessible 'IIF' accepts this number of arguements" - this was returned on the first attempt above. "The Hidden expression for the text box 'Amendment_1' refers to the field 'Amendement_1'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case." - I get this error on the last two attempts above. Any suggestions?
Hiding rows with blank or 0 data
Hi all. I am attempting to hide blanks when there is no data for a table value: Value YTD hide = CALCULATE('Month_Dataset'[Total MTD Value],CALCULATETABLE(DATESYTD('DIM_Date'[Date],'DIM_Date'[Value YTD hide]=TRUE))) I created a column in the date table that gives a true/false indicator if the date is greater than today's date: DatesWithValues = 'DIM_Date'[End of Month]<=MAX(Month_Dataset[Month End Date]) This is working but when I try to hide data that has $0 value, I get the following error: Only constant date value is allowed as a year end date argument. Any ideas on fixing this? Heather
