Have the following table and would like to filter on Category and Owner

[Anonymous]

Have the following table and would like to filter on Category and Owner and have total days delay sum.

Create a filter with Us Them and when selecting Us come back with days delay like:

DCN   2

Scope 4

Access 3

Material 10

Another filter with Scope DCN Access Material and when selecting Scope it returns with:

Scope 8

Job     Category 1  Owner 1    Days Delay 1    Category 2   Owner 2   Days Delay 2

1          DCN              Us              2                    Scope               Them          4

2           Scope           Us              4                    Access              Us               3

3           Access          Them         3                    Material            Us              10

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Pleae perform the following steps in Power BI Desktop.

1.Duplicate your current table in Power BI Desktop query editor.


2.Remove the last three columns in your original table and rename  Category 1 ,Owner 1 ,Days Delay 1 to   Category , Owner , Days Delay .


3. Remove the three columns(Category 1 ,Owner 1 ,Days Delay 1) in your duplicated table and rename  Category 2 ,Owner 2 ,Days Delay 2 to   Category , Owner , Days Delay .


4. Append queries in the two tables.


5. Create table visual using category and Days Delay fields. Use category and owner slicers to filter the table visual.




Regards,
Lydia