Filtering out zeroes across multiple fields

[Anonymous]

Hi all

I'm trying to create a single visualisation that includes multiple fields, to report across 75 projects. Because I'm reporting across so many project rows, I'd like to filter out any projects with 0 against a value so that they're not included in the clustered column chart. 

	Group1	Group2	.....
	Value1	Value2	Value3	Value4	....
Project1	1	0	2	3
Project2	0	3	3	0
project3	0	4	0	1
Project4	1	1	0	7

However, I can't seem to see a way to apply a filter to specific fields - just the visualisation as a whole, so that if (using the table above) I filter out 0 for value1, project2&3 are removed entirely. 

Is there a trick I'm missing to apply a filter across all the values in my visualisation, or on 1 field at a time?

[Fowmy · Accepted solution]

@Anonymous 

In Power Query, you can UnPivot all the Values columns and filter out the zero rows, this way you get the results expected.

Refer : 
https://www.youtube.com/watch?v=_YjFGsS9lNY&t=23s

https://www.youtube.com/watch?v=Vff2kRBM95o&t=0s

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn