separation in 2 of a table

[Anonymous]

Hello everybody,

I want to separate this table in two parts (in 2 tables) : 

One table with only the "improductives" and an other with only the "productives"

In fact I want one table like that, with the total : 

And an other like that, with the total : 

I have already this on excel for example to be more understandable :

So, I don't know how to proceed, it's why I do this post. I hope somebody could help me.

If you want more details, don't hesitate to ask me.

Sincerly, a trainee.

[PaulDBrown · Accepted solution]

Create two visuals as you have shown, and in the filter pane  set the value of the I/P field to "improductive" in one visual and "productive" in the other.

[HashamNiaz · Accepted solution]

Hi @Anonymous !

You can apply visual level filter on [I/P] column to restrict the visual to only show [improductives / productives]

Another solution would be to go in Power Query Editor & refrence the query and then filter query based on [I/P] column, name this query as [improductives] table

Do the similar agan but this time filter query based on [I/P] column, name this query as [productives] table

Regards,

Hasham

[MintuBaruah · Accepted solution]

Hello @Anonymous 

I tried this solution and it is working. 

You can create 2 Tables and apply filters on both of them.

Screenshot:

Thank you,

Mintu Baruah

[Anonymous]

Hi @MintuBaruah , yeah it's what I have done. Thanks for your help, have a nice day ! 

[HashamNiaz · Accepted solution]

Hi @Anonymous !

You can apply visual level filter on [I/P] column to restrict the visual to only show [improductives / productives]

Another solution would be to go in Power Query Editor & refrence the query and then filter query based on [I/P] column, name this query as [improductives] table

Do the similar agan but this time filter query based on [I/P] column, name this query as [productives] table

Regards,

Hasham

[Anonymous]

Hi @HashamNiaz , thank you for the solution 🙂 Have a nice day. It was more simple that I have expected hehe

[PaulDBrown · Accepted solution]

Create two visuals as you have shown, and in the filter pane  set the value of the I/P field to "improductive" in one visual and "productive" in the other.

[Anonymous]

Hi @PaulDBrown  , thank you for the solution 🙂 Have a nice day. It was more simple that I have expected hehe