Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
happel
Regular Visitor

Enabling Data Labels only for one out of many serieses in a chart?

I have a chart with a combination of a stacked bar chart and a line chart and I only want the data labels to be visible for the line-chart.
I know I can manually deselect the data labels for every series of the stacked bar chart. But these series are changing over time, so I can't foresee which series will be there next week, and therefore I can't deselet them today. 
Also, there are so many series that it doesn't make sense to go through all of them one by one to deselect them.

 

So question is: Is there any way to say: By default no data labels, except this one defined series (the line series).

happel_0-1707379560033.png 

happel_2-1707379605583.png

 

And before someone now says it doesn't make sense to show that many serieses in a bar chart:
This chart is part of an embedded dashboard in our customer-facing product. That means, every customer only see their own (a very small subset of these) serieses and the chart will then make sense.

BTW: One more reason why I can't deselect these serieses manually, because I'm developing against our dev-environment, but the serieses on production will be totally different.

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@happel , What I have done is, I created a measure that has value for only one series. Now instead of fixed series we can use TOP Series too
Use the latest measure driven label, in value used a measure
Label = if(Max('Item'[Category]) = "Category 1", [net], BLANK())

amitchandak_0-1707389980510.png

 

for Top category use like
Label =
var _top = maxx(INDEX(1, ALLSELECTED('Item'[Category]), ORDERBY(CALCULATE([Net],REMOVEFILTERS('Item'[Brand])), DESC)),[Category])
RETURN
if(MAX('Item'[Category])= _top, [Net], BLANK())

amitchandak_1-1707390377582.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @happel ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Ada Wang

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

amitchandak
Super User
Super User

@happel , What I have done is, I created a measure that has value for only one series. Now instead of fixed series we can use TOP Series too
Use the latest measure driven label, in value used a measure
Label = if(Max('Item'[Category]) = "Category 1", [net], BLANK())

amitchandak_0-1707389980510.png

 

for Top category use like
Label =
var _top = maxx(INDEX(1, ALLSELECTED('Item'[Category]), ORDERBY(CALCULATE([Net],REMOVEFILTERS('Item'[Brand])), DESC)),[Category])
RETURN
if(MAX('Item'[Category])= _top, [Net], BLANK())

amitchandak_1-1707390377582.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors