Turning Off Specific Data Label in Visuals

[Piyush_Ghungrud]

Hi Community,
I have been working on a stacked column chart that has multiple products(products > 100 & products are in legends). I wanted to turn off data labels for many of the products and ON for a few products(less than 5). For this to happen, I have to specifically go to the data labels of the visual and check for each and every product in the visual and turn off the data labels which is very time-consuming(as the data gets refreshed and new product also gets added to the visual).

Is there any other way to achieve this?

Please let me know your valuable suggestions.
Thank you 🙂

[Anonymous]

Hi @Piyush_Ghungrud ,

As far as I know, applying setting to Series is a good workaround that Power BI Desktop support us to control the data lable. Here I suggest you to turn off the data labels which you don't need by this function.

Now you think it will take too much time due to your large data size, I think you can load a sample table which has the same data model like current one and then turn off the data labels you don't need. Then you update your data source with final data and refresh your table.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Piyush_Ghungrud]

Hi @Anonymous ,

thank you for your valuable suggestions.
I have tried the way you mentioned however the problem arises when the data after refresh come up with new products. For the new products, the data label is always on, so it need to be turned off again. 
Please let me know your thoughts on this.
Thank you 🙂