Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
@Aliafshari,
In the visual level filters of your visual, set the value of the measure to be not blank and not 0.
Regards,
Lydia
Could you please share dummy data of your table and post expected result here? Do you want to show all values in Matrix that is greater than 0?
Regards,
Lydia
Hi lydia
Thanks for yoyre attention.
My matrix table is here and I would like to suppress the zero value, actually the red rows.
MAINACCOUNTID | Site | Quantity | sum inventory amount |
1411101 | 1 | -1,438 | -36,623,716 |
1411101 | 2 | 39,574 | -14,109,014,584 |
1411101 | 3 | 2,032 | 138,402,199 |
1411101 | 4 | 273 | 273 |
1411201 | 1 | 0 | 0 |
1411201 | 2 | 0 | 0 |
1421101 | 2 | 13 | 3,743,660,542 |
1421101 | 3 | 14 | 14 |
1431101 | 1 | 265 | 14,096,138 |
1431101 | 2 | -1 | -681,882 |
1431201 | 1 | 0 | 0 |
@Aliafshari,
In the visual level filters of your visual, set the value of the measure to be not blank and not 0.
Regards,
Lydia
Thanks Lydia
Hi Lydia Thanks for youre attention, my matrix table is here:
MAINACCOUNTID | Site | Quantity | sum inventory amount |
1411101 | 1 | -1,438 | -36,623,716 |
1411101 | 2 | 39,574 | -14,109,014,584 |
1411101 | 3 | 2,032 | 138,402,199 |
1411101 | 4 | 273 | 273 |
1411201 | 1 | 0 | 0 |
1411201 | 2 | 0 | 0 |
1421101 | 2 | 13 | 3,743,660,542 |
1421101 | 3 | 14 | 14 |
1431101 | 1 | 265 | 14,096,138 |
1431101 | 2 | -1 | -681,882 |
1431201 | 1 | 0 |
I must say that the sum inventory amount is a measure and the question is how to do not show the red rows.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |