Forum Discussion

jasemilly's avatar
jasemilly
Icon for Helper III rankHelper III
10 months ago
Solved

Custom data label on area chart not showing value. Measure displays correctly on a table

Hi I am trying to use the custom data label on an area chart to provide infomation percentage change, but it doesn't display at all. I can put the measure in a table, it always displays correct...
  • Anonymous's avatar
    Anonymous
    10 months ago

    Hi jasemilly ,

    Thank you for your follow-up and for pinpointing that the issue was due to missing dates in the fact table. If the dataset doesn’t cover a continuous date range, visuals like the area chart may not render labels for dates with no data, even though the measure works correctly in a table.

    To fix this, create a separate Date table, mark it as a Date Table in your model, and link it to your fact table. Using functions like ISINSCOPE() or COALESCE() can help ensure your measure returns values for all dates, allowing labels to display consistently.

    Glad to see you and tayloramy have already identified the root cause. If you can provide an updated PBIX via a public link, the community can review and confirm your solution resolves the visual issue.

     

    Thank you.