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.
Hi Anonymous
Create a measure, for example
Measure = IF(ISFILTERED('Date'[Date]),"filtered"," ")
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.