Header (distinct value) to be displayed in Paginated Report (Report Builder)
Hi, I need to display some name & id as a header. We are allowing only one name to select from filter, when we display as header using text box or table or list, we are getting same values duplicated in multiple rows though only row to be expected. Is there a way on this Paginated Report to display only one value as however I try same value getting repeated in multiple rows. Please let me know if you need more details. Its getting repeated like as in snap below: To be displayed like: Thanks NagReplacing valuse based on ID column (Conditional Formatting)
Hello guys, I would like to replace the "63" value in the TT_ACT_ID column if the project number is "168907" in column TT_PRJ_ID. I have used replaced value with a if formula but it doesn't work. I've tried a couple of dax formula, see below. The formula I've used are: = Table.ReplaceValue(#"Renamed Columns", 63, each if [TT_PRJ_ID]= "168907" then "13" else [TT_ACT_ID] , Replacer.ReplaceValue,{"TT_ACT_ID"}) = Table.ReplaceValue(#"Renamed Columns", each [TT_ACT_ID], each if [TT_PRJ_ID]= "168907" and [TT_ACT_ID]= "63" then "13" else [TT_ACT_ID] , Replacer.ReplaceValue,{"TT_ACT_ID"}) Thanks guys! Greetings, Ka-Lok
