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,
Sorry can't upload to the cloud --- I'm restricted, but here's a sample data(below). Put simply that I wanted to get the percentage Numerator/Denominator but what I want is to not show in a graph any entries that are blank percentage or zero percentage.
I already played around with HASONEVALUE but just couldn't get it to work. Any help please? Thank you.
Numerator | Denominator |
14 | 85 |
33 | 63 |
88 | 63 |
0 | 52 |
33 | 89 |
12 | 79 |
28 | 105 |
0 | 95 |
34 | 57 |
7 | 60 |
76 | 81 |
27 | 90 |
49 | 104 |
65 | 50 |
0 | 54 |
16 | 103 |
82 | 56 |
62 | 75 |
0 | 109 |
57 | 100 |
Solved! Go to Solution.
the simpliest way is just to filter the visuals where you don't want your blank and zero values.
the simpliest way is just to filter the visuals where you don't want your blank and zero values.
OKay thanks, actually there are three columns that I need to check, but I think I know what I need to do now.
I'll just sum up all the three and only show those records which has greater than 0 total, meaning if atleast one of the three fields has value in it, a record should show.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |