Suppression of values less than 10 in visuals

[psrikoo]

Hello!

Do we have an option or feature in powerbi where we can suppress data with values less than 10 in the visuals? I used dax code, 

Dax code:

Students S =

VAR Totalstcount = DISTINCTCOUNT(DemoInfo[Student])

RETURN IF(Totalstcount = 0, 0, IF(Totalstcount > 9, Totalstcount, "<10"))

it manages to get the '<10' on visuals but it does not take into account values <10 while caluculating percentages and those values are not shown in the visuals when filtered. I want a visual like where it can calculate the <10 values in the percentages but show just <10 when the actual number are there. 

Thank you in advance. Please help me find a solution.

Regards,

Priya Srikoo.

[v-kelly-msft]

 Hi  @psrikoo ,

Can you show me a screenshot of your expected output?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[psrikoo]

Hi,

In the below, there are two dashboards with different fields under values. 

1. There are distinct student id in the visual with 1(example Race/Ethnicity1) under values.
2. There are suppressed measure showing <10 values with 2 (example Race/Ethnicity2) under values.
3. There are distinct student id measure in the visual with 3(example Race/Ethnicity3) under values.

The Test sample shows Race visuals with different values for measure as stated above, the Race/Ethnicity1 if we right click for visuals 

• We can see different option to see the data underneath the visual along with whole data underlying.

• When can see only show as table options and when we click as show a table values which are less than 10 show '<10' but the visual will not show anything for those values.

• When can see only show as table options but can see the values less than 10. If there are percentages they are calculated accurately but shows less than 10 values (example 1,2,5,8 etc) in the table view.

I don't want t show the show as table or show as a data point table to my external users, How do I do it?(I know we can use an option does not allow end user to download/export but I want which turns off such feature. Id Microsoft has such feature and I'm not aware please let me know.

Here I want a visual which calculates <10 values/percentages and show up in visual <10, unlike the one which is shown below, when I take real data and measure it shows up correct percentage but when a formula is applied as mentioned above it does not take <10 values into consideration. So please help me finding a formula in dax or a feature in powerbi which helps in suppression.

Thank you in advance!

Image for example:

[v-kelly-msft]

Hi @psrikoo ,

A bit complex,could you pls upload your .pbix file to onedrive business and share the link with us?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[psrikoo]

Hi,

Good Morning!

I build a pbix file with dummy data which would help in understanding my questions and I dont understand how to uploa it here in my post. Can you please let me know how to do it in case if you know.

Thank you!

Regards,

Priya.

[y3wan]

Hi psrikoo,

I have been also researching a solution for the suppression barriers.

Would you kindly explain how you suppressed your data without altering the column type (number) in your case?

Much Appreciated

[psrikoo]

Hi y3wan,

I wrote a dax code where it calculates the percentage of each lengent value using a var in the code and return the percentages with accurancy (just like we get in 100% stacked bar chart). For values less than 10, I used the above formula that I mentioned using stacked column chart having the percentages on the dat bars and supressed values as tooltip. (if there is a attachment option tp this post it would have been nice to share the pbix file with dummy data). Let me know if you have more questions related to it. Thanks!

Regards,

Priya Srikoo.

[Teshuda]

Hi Priya, 

Have you found any solution to your query? 

I am interested to find out about this, as I have similar issue. when I use the visual filter if the values are under 10, extrapolate the rest of the values to 100%. (e.g. We want to report in Ethnic Minority for 60 employees. 50 declared this information, out of these 50 ( 33 are white, 9 ethnic minority and 8 Prefer not to say), the visual with filters would say 100% are white which is not true. Would be better solution to make blank the whole visual for this case? 

Many thanks

Oscar. 

[amitchandak]

@psrikoo , You can use the visual level filter.