Dynamic rows

[Tsiry]

Hello community,

Is there a way to create a table with dynamic rows in Power BI based on a slicer?

I have 3 values in my slicer :
Product
Product category
Product subcategory

If I choose  Product on my slicer, I'd like to have a table like this:

Products	Values
Product1	1000
Product2	3400
Product3	477

When I choose Product category, it will be like :

Product categories	Values
Categ1	367373
Categ2	838333
Categ3	220004

And so on,

[andhiii079845 · Accepted solution]

You can use field parameters in this case:
https://www.sqlbi.com/articles/fields-parameters-in-power-bi/