Good morning, I'm trying to build a report that will allow users to select a school district & school that will update visuals according to the selection. My visuals and data sources are mapped via a "district_id" and "school_id" which is a numeric code to dimension tables that include district ID's and names, and school ID's and names. In the report I would like to display the appropriate district names (Jones County, Brown County, etc.) and school names (Harris Elementary, Thomas Elementary, etc.). As district and school names are subject to change, I don't want to link data via names but based on the underlying ID keys that are time invariant. The name to be displayed will be the ones in the school and district dimension tables. I was wondering if there were any resources or known solutions that address displaying text different to the underlying filter values? Thanks!
... View more