I would like to create a dashboard where the users of the dashboard are able to select the dimension columns and fact columns that they want to see the values for, and these should appear on the dashboard as a matrix to be able to view the values for the chosen columns.
The list of dimension columns and fact columns are to be displayed as two separate multi-select slicers.
Basically, when a user accesses this dashboard, they have the capability to choose the specific columns(dimensions and facts) that they want to see the values for.
The data model is a simple star schema, with 1 fact table and 6 dimension tables.
Please help me in designing this dashboard.