Change table dimension with filter

Get Help
1

Change table dimension with filter.

if i have these three dimensions - product - product_category - product_type - in a table/pivot table.

lets say current the table is displaying product, is it possible to change the dimension of the table with a filter?

After the user would select the filter - product_category - the table would change with just product_category dimension showing. Is this possible?

with looker you'd use a parameter and it i'm pretty sure it can be done with powerbi witha drill down.

2

If you create a question using a SQL query, you can have a case statement in the SQL that's linked to a parameter. It would be easier if it could be done without SQL.

1 Like
3

so this would just be

select case when groups end as product_stuff, *
from products

i'm not able to just use the dataset, so i'd create this.