cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Turning Off Specific Data Label in Visuals

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

Piyush_Ghungrud_0-1676287344128.png

 

Is there any other way to achieve this?

Please let me know your valuable suggestions.
Thank you 🙂

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

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.

RicoZhou_0-1676357433199.png

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.

Hi @v-rzhou-msft ,

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 🙂

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.