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 have a table visual with a visual filter for zero suppression. Now I want to turn off the total for 2 out of 7 columns in my tables. I tried using ISFILTERED function but it doenst work if there is a visual level filter. Is there a way i can acheive both zero suppression and total removal from certain columns. Appreciate some help. Here is the sample data. Column2 should not be totalled and zero row should be suppressed.
Original data:
Column1 | Column2 | Column3 |
A | 100 | 250 |
B | 200 | 500 |
C | 300 | 750 |
D | 400 | 1000 |
E | 0 | 0 |
Total | 1000 | 2500 |
Desired output:
Column1 | Column2 | Column3 |
A | 100 | 250 |
B | 200 | 500 |
C | 300 | 750 |
D | 400 | 1000 |
Total | 2500 |
Solved! Go to Solution.
Try the following:
1. Go to Format —> Field formatting
2. Select the field
3. Set the Font color to white (set it even if it already displays white)
4. Toggle “Apply to values” off
5. Toggle “Apply to total” on
Proud to be a Super User!
Try the following:
1. Go to Format —> Field formatting
2. Select the field
3. Set the Font color to white (set it even if it already displays white)
4. Toggle “Apply to values” off
5. Toggle “Apply to total” on
Proud to be a Super User!
Although this was not I was not looking. But this works for me for now. Thanks for a simple solution.
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 |