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.
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?
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |