To get reference line for each month in power BI.

To add a reference line to a bar chart in Power BI, you can follow these steps:

1. Create a bar chart with the desired fields.

2. Right-click on the chart and select "Format".

3. In the "Format" section, expand the "Data Labels" and select "Line".

4. In the "Line" section, you can adjust the line color, style, and thickness.

5. To add the reference value, you can either use a calculated field or a measure. For example, if you want to add a line at the average value of the data, you can create a measure using the following DAX formula:

   = AVERAGE(Table[Field])

   Where "Table" is the name of the data table and "Field" is the name of the field used in the chart.

6. Add the measure to the chart and adjust the position of the line in the "Line" section of the "Format" panel.

7. To display the reference value in the chart, you can add a data label to the line. Right-click on the line, select "Add Data Label", and adjust the label format and position as desired.

By following these steps, you can create a reference line in a bar chart in Power BI similar to Tableau.