Forum Discussion

san17680's avatar
san17680
Icon for Helper II rankHelper II
3 years ago
Solved

Reference line for last year spend

Hi Team,

 

I am looking to get last year spend reference line as shown in the image which is created on tableau(top right). i have attempted this in power bi but somehow not getting the desired result (top left). 

Reference lines should be for domestic and international as shown in the right image.

The totals are shown at the bottom for 2021 (current year) vs 2020 (last year)

 

Please advise 

Thanks

 

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi san17680 ,

     

    My bad it's not turn off you need to change the size of the line to 0 (stroke width) kind of turn off.

     

     

     

     

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi san17680 ,

     

    One options is to create a Line and clustered column chart and then use the previous Year on the line, turn of secondary axis, turn of lines, turn on markers then add labels:

     

     

    You can also try and check some customs visulizations

    • san17680's avatar
      san17680
      Icon for Helper II rankHelper II
      3 years ago

      Thank you MFelix for your response

      how do we turn off the lines, mine chart looks like this

       

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        3 years ago

        Hi san17680 ,

         

        My bad it's not turn off you need to change the size of the line to 0 (stroke width) kind of turn off.