Basic functionality: Reference Lines in Bar Chart per category

[carlos_viz]

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 bar / category. Power BI is ignoring the categories / bars and adding one reference line only for all categories. Basic stuff. 

Thanks for your help

Carlos

[carlos_viz]

Thanks for your answer. I typically use the columns when representing a time dimension, however, for other data attributes such a product category, region, etc. bar charts are for several reasons stronger in my point of view. 

It seems a little strange that same charts - just transponsed - have different functionalities available. 

Thanks again for taking the time. 

Br,
Carlos

[rajendraongole1]

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)

This ONE IDEA opens ENDLESS POSSIBILITIES | Combining Reference Lines and Parameters in Power BI (yo...

Hope this helps.