Forum Discussion
Helper IIIData label values shows twice
The data label value shows twice but i wanted to show only one time.
JothiG , Open and check in the label. Have you enabled additional label items like details. Just keep one under value
Hi JothiG
This happens because it’s a combo chart (columns + line) showing the same values in both series.
If you’re using two different measures that just return the same value, simply turn off data labels for one series (either columns or line) in the Format pane.
If you use the same measure for columns and line:
The fix is to create a second measure that references the first, e.g.Sales_Duplicate = [Sales]
Use [Sales] for one series and Sales_Duplicate for the other. Now you can disable labels on one series only.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi JothiG
This happens because it’s a combo chart (columns + line) showing the same values in both series.
If you’re using two different measures that just return the same value, simply turn off data labels for one series (either columns or line) in the Format pane.
If you use the same measure for columns and line:
The fix is to create a second measure that references the first, e.g.Sales_Duplicate = [Sales]
Use [Sales] for one series and Sales_Duplicate for the other. Now you can disable labels on one series only.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
JothiGthank you. it is working now..
- amitchandak
JothiG , Open and check in the label. Have you enabled additional label items like details. Just keep one under value