Conditional data labels on graphs

[sakarim]

Hi,

I work with health data and have to suppress counts of less than 5 on graphs. I am looking for a solution to display a data label on the chart once filters are applied to show "<5" where counts are less than 5 rather than it being omitted or blank (see example picture below). Is there a way to do this?

[Jihwan_Kim · Accepted solution]

Hi, @sakarim 

One way to achieve this is fixing the number format by using Tabular Editor in Power BI.

Please check the below picture and the sample pbix file's link down below.

I created a calculation group inside Tabular Editor in Power BI Desktop.

If you go into the Tabular Editor, and if you check the "Format Striing Expression", you can see how I wrote DAX.

https://www.dropbox.com/s/gbzuh1x2f2miism/Sakarim.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Jihwan_Kim · Accepted solution]

Hi, @sakarim 

One way to achieve this is fixing the number format by using Tabular Editor in Power BI.

Please check the below picture and the sample pbix file's link down below.

I created a calculation group inside Tabular Editor in Power BI Desktop.

If you go into the Tabular Editor, and if you check the "Format Striing Expression", you can see how I wrote DAX.

https://www.dropbox.com/s/gbzuh1x2f2miism/Sakarim.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[sakarim]

worked, thanks! Is there a way to have 0 not included in the <5? 

[Jihwan_Kim · Accepted solution]

Hi, @sakarim 

Thank you for your feedback.

I am not sure if I understood your last question correctly, but please check the below picture and the sample pbix file's link down below.

https://www.dropbox.com/s/7mrjew3l7o3vhft/Sakarim.pbix?dl=0 

[sakarim]

exactly right, thank you so much!😁

[vanessafvg]

are you wanting to group everything under 5 in one bucket and have its own bar to display?  is that what you asking?

[sakarim]

For any variable where the count is less than 5, I just want a data label that shows <5 rather than it being blank. For example, the picture I included shows a breakdown by age category and you can see the 55-64 age range for the pink bar is blank because it is less than 5 for the category. I want there to be a label that says "<5".