Forum Discussion
Filtering out zeroes across multiple fields
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?
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=23shttps://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 🙂
1 Reply
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=23shttps://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 🙂