Need Help - how to limit values from displayed in the visualization

[Ibrahim_shaik]

Hi Power Bi community,

I have connected my report to the MySQL Database and i refresh the report from power bi service and i have also scheduled refresh.

How to restrict values not display in the chart after a certain limit value for example values which are <10 or =0 or <0

As you see the orange line is touching down which are the 0 values i don't want to display that data.

please suggest a solution.

Thanks&Regards,

Ibrahim

[manvishah17]

Hi @Ibrahim_shaik ,
You can simply apply visual level filter 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Ibrahim_shaik]

Hi @manvishah17 @mh2587 ,

Thank you so much for the response.

I will apply the visual level filter and check if it gives me the required result.

Thank you!

[Ibrahim_shaik]

Hi @manvishah17 @mh2587 ,

If i use visual level filter the other variables in the chart are also getting filtered, I don't want to filter other variables i only want to filter line in the line and stacked column chart.

columns are also being filtered with the visual level filter.

[mh2587]

You can use Visual filter to restrict the measure and set the value greater than 10 in advance option.