Forum Discussion

thomasreick's avatar
thomasreick
Icon for Resolver I rankResolver I
3 years ago
Solved

Hide Values in visual when data condition is not satisfied

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)...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

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.