Hide Values in visual when data condition is not satisfied

[thomasreick]

Hello there and all the best for a healthy Year 2023.

My queston is rather an "is it possible"-one than a call for help.

Sitiuation:

We are calculating a KPI called "Net Promoter Score (NPS)" Definition (Wikipedia) from results of customer interviews.

Due to low number of prticipants in some periods, the results of these periods should neither be shown in the visual nor the NPS calculated to be plotted.

I have a combination chart of bars and lines showing the Number of Participants  in Columns and the calculated NPS as Markers without lines.

Is there  some workaround to have special data point s from a timeseries excluded/not plotted but keep the period in the X-Axis?.

Appreciating your answers.

Thank you very much

Thomas

[v-jingzhang · Accepted solution]

Hi @thomasreick 

This is possible. You may have a look at this article Add a filter to a report in Power BI - Power BI. It introduces the filter pane in Power BI. You can set filters at three different levels for the report: the visual level, the page level and the report level. In your senario, you can try the visual level filter. 

If there is a fixed threshold for the KPI to hide some values, you can filter the KPI field on that visual. Compare its value to that threshold value. The filter types are different according to the field data type. 

If the threshold value is not fixed, you can create a measure to get/calculate the threshold value and compare it with the KPI value, then return a value e.g. 1 if the condition is satisfied. Add this measure to the visual as a filter and set it to show items when value is 1. 

If you don't want report users know this filter, you can click the eye icon to hide it. You can click the lock icon to make report users not able to change this filter. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.