Forum Discussion
Basic functionality: Reference Lines in Bar Chart per category
Dear community, I'm unable to create a bar chart that is spilt by categories (i.e. countries) where actuals are represented in the bars, and the target is represented as a reference line in each ...
Hi carlos_viz - Using the Line and Clustered Column Chart is often the most straightforward approach as it naturally aligns with how Power BI handles different data series.you'll need to use the "Analytics" pane to add reference lines that are specific to each category.
select the Clustered Column Chart (for your actuals).Drag your "Actual" measure/column to the Values field.Drag the category (e.g., "Country") to the Axis field.
How To Add a Dashed Target Line in Column chart in Power BI (youtube.com)
Hope this helps.