Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MaximeVall
Helper II
Helper II

separation in 2 of a table

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"

MaximeVall_0-1621501547007.png

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

MaximeVall_1-1621501625023.png

And an other like that, with the total : 

MaximeVall_2-1621501653039.png

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

MaximeVall_3-1621501718222.png

 

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.

3 ACCEPTED SOLUTIONS
PaulDBrown
Community Champion
Community Champion

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.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

HashamNiaz
Solution Sage
Solution Sage

Hi @MaximeVall !

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

View solution in original post

MintuBaruah
Helper III
Helper III

Hello @MaximeVall 

 

I tried this solution and it is working. 

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

 

Screenshot:

Community Answer.PNG

Thank you,

Mintu Baruah

View solution in original post

6 REPLIES 6
MintuBaruah
Helper III
Helper III

Hello @MaximeVall 

 

I tried this solution and it is working. 

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

 

Screenshot:

Community Answer.PNG

Thank you,

Mintu Baruah

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

HashamNiaz
Solution Sage
Solution Sage

Hi @MaximeVall !

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

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

PaulDBrown
Community Champion
Community Champion

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.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.