Forum Discussion

mdm2025's avatar
mdm2025
Icon for Helper I rankHelper I
1 year ago
Solved

Custom Reference Line Using DAX

Hello everyone,    I wanted to check if anyone has found a workaround for setting up a custom calculated reference line in Power BI. While the default reference line options are useful and make se...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mdm2025,

    since the combo chart isn’t fitting your visual needs, and you are trying to show a separate custom line for each column using a measure, your current workaround with an extra column makes sense for now.
    At the moment, Power BI doesn’t have a built-in way to draw individual lines on each bar using a measure. That’s why people usually go for the combo chart method, even though it has its own limitations.

    Hope this helps if you have any queries we are  happy to assist you further.
    Best Regards,
    Harshitha.

wardy912's avatar
wardy912
Icon for Super User rankSuper User
1 year ago

Hi mdm2025 

 

 You will need to create a measure similar to the below, I am setting different targets for different days of the week.

 

Custom Reference Line = 
SWITCH(
    SELECTEDVALUE('Date'[Day Name]),
    "Monday", 1500,
    "Tuesday", 1300,
    "Wednesday", 500,
    "Thursday", 1200,
    "Friday", 900,
    "Saturday", 800,
    "Sunday", 700,
    BLANK()
)

 

Add that as the line y-axis in a line and clustered column chart for the following result

 

You could also add it as a tooltip for better visibility

 

 

I hope this helps! Please give a thumbs up and mark as solved if it does, thanks!