Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
thomasreick
Resolver I
Resolver I

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)" 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

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1674099100012.png

 

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. 

vjingzhang_1-1674099479070.png

 

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

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

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. 

vjingzhang_0-1674099100012.png

 

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. 

vjingzhang_1-1674099479070.png

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.