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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.