Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
in the picture below I have a report that it have some measures and fields, as you can see has lines all values are zero, thus leaving the report with unnecessary size, how can I prevent these zero values are displayed?
when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?
@vitexo87 wrote:
when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?
The visual level filter only affects that visualization and it won't filter the report. May I know why a filter is not preferred in a visual? Up to my knowledge, there's no other way than a filter. Or you may prefer a filtered calculated table or a filtered dataset when connecting the data source?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |