I am building a dashboard (in online template builder in Fusion BIP) with various charts and detailed information, all based on one dataset in a BI Publisher Data Model. At the top I have 4 KPI cards that are structured as Data Fields that I dropped into a Layout Grid.
The dashboard is interactive in that when you click on a particular value in a chart the rest of the charts and detailed data table at the bottom react and filter for those values. The only place where this does not appear to change is in the KPI cards that are Data Fields.
What I want if for the the KPI Data Fields to also dynamically change when clicking on values in the corresponding charts. As it appears that the Data Fields can't be dynamic from what I've seen, I instead tried using a data table (that is dynamic from testing I did) that I was able to remove the Heading, detail row's Padding and make the detail row's font colors transparent with the background, to effectively hide or make the detail information invisible so that I would only have the Summary row that would still update as I click on the chart values. This is what is looks like:
The problem is that when it is formatted this way to make the other detail information invisible then when I Preview or Run the report this particular element just stays in this "Processing…" status.
However as you can see on the table on the right in the above screenshot where I haven't made the other elements invisible it renders just fine.
Is this some kind of bug, an/or is there another way to have this Data Fields update dynamically? I'm happy to provide the data model and Report template if it helps in any way.
Thanks in advance!
