Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.