Forum Discussion
Helper IHow to make a table filtered by specific category
Super UserTomasPac , Not very clear. You should have object in a common table, so that it can filter all the tables
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
Helper II need only one table,
My example that I have attached is for supply orders.
I'll try to explain my example:
1. The column "Object" in my table holds site names, which are making supply orders.
2. Each site has it's own orders as a table row.
3. There are many different kind of data for an order, like "supplier", "quantity", "price", "date planned" and so on.
So right now if one "Object" has 5 supply orders, my table has 5 different rows with the same "Object" value.
What I need is "Object" values to be like a category for every other subcategory and value, like in my screenshot no.2
For example if "Object" values are site1 and site2 so the table should look like this:
Object | order no | quantity | price | date planned
site1-----------------------------------------------------------------------------------
order1 10 10 2021-01-01
order2 20 20 2021-01-01
site2-----------------------------------------------------------------------------------
order3 15 30 2021-01-12
order4 40 5 2021-01-07
Is this more clear?