Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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).
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.
Solved! Go to Solution.
@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())
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())
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.
@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())
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())
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |