Forum Discussion
Linked Dynamic Header not blank when no parent selected
1) I have two Power BI table visuals, Visual 1: for parent records, Visual 2: for child records. 2) There is a 1:n relationship between the two underlying queries. 3) Above Visual 2 I have a Card h...
To solve this requirement I had to create a measure (labelled "Header", see below) on the Parent Table to hold the dynamic Header which I placed in a Card visual:
Header = IF(HASONEVALUE(PARENT_TABLE[FIELD_1]),FIRSTNONBLANK(PARENT_TABLE[FIELD_1],NOT ISBLANK(PARENT_TABLE[FIELD_1]))," ")
ISFILTERED didn't work for this requirement as the filtering is based on the user clicking on one of the records on the screen to highlight that record, then child tables are filtered based on the relationship between parent and child.
you have to do this in one or more measures of the child table. use isfiltered or isinscope to have no values when nothing is selected
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/