cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
agalbraith
Regular Visitor

Removing data from chart when sample size too small

I have searched this forum up and down and have yet to find a solution. My colleague and I have large data sets and we are utilizing bar charts or pie charts with filters to display our company data. We have multiple filters on a page that could be gender, ethnicity, first gen students, etc. The problem is that when people select multiple filters there may not be enough respondents that we do not want to display those percentages then. For instance, not enough female, native hawaiian, first gen students (3 filters) to show that particular percentage. We want to be able to replace the data in the chart to say something along the lines of "sample size too small". Is there some sort of dax in order to do that per visual? We would know on the back end which samples are too small. We want the percentages of other categories to stay true when filtered, but to replace a given data point where there are too little responses. OR is there a way in which it can be done in BI that we can set a page/graphic to a given number of respondents so that when filters are selected it knows that there's less than 5 responses for a particular group and it won't display that one, but still keep the other percentages true?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @agalbraith,

As Greg said, card visuals with conditions color formatting and expression should be a good choice to achieve your requirement. If you want some more detailed operations steps, you can take a look at the following blog:

Display Custom Message in the Visual Until a Selec... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @agalbraith,

As Greg said, card visuals with conditions color formatting and expression should be a good choice to achieve your requirement. If you want some more detailed operations steps, you can take a look at the following blog:

Display Custom Message in the Visual Until a Selec... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Greg_Deckler
Super User
Super User

@agalbraith I would create a measure used in a Card visualization above your graphic. The measure would either return BLANK() or your message depending upon the selection criteria. Here is an example: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!