Forum Discussion

Fabrice_Windus's avatar
Fabrice_Windus
Regular Visitor
1 year ago
Solved

Combo Chart: switching line label values does not work

I want to add data values in a table format at the bottom of a bar chart, using a combo chart (line and stacked column chart). To do that, I created some measures with fixed values like -1, -2, ... a...
  • burakkaragoz's avatar
    1 year ago

    Hi Fabrice_Windus ,

     

    Yep, this is a known quirk with combo charts in Power BI — the line data labels don’t always respect dynamic measure values when combined with columns. It works fine in a standalone line chart, but combo visuals can behave differently due to rendering priorities.

    Here’s a workaround you can try:

    1. Instead of using fixed values like -1, create a measure that returns the actual value you want to show, but only under certain conditions. For example:
       LineLabel = IF(SELECTEDVALUE('YourTable'[Category]) = "X", [YourActualMeasure], BLANK())
    1. Add this measure to the line values section.
    2. In the Data labels settings, make sure:
      • Data label is turned on
      • Value is set to "Value from field" and you select your dynamic measure
    3. If it still doesn’t work, try switching the chart type to line chart, set the label, then switch back to combo — sometimes this forces the visual to refresh correctly.

    If none of that works, you might consider using a custom visual like Deneb or Charticulator for more control over label rendering.

    Let me know if you want help building a sample measure or visual config.

    If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
    translation and formatting supported by AI