Forum Discussion

Nicki's avatar
Nicki
Icon for Helper III rankHelper III
5 years ago
Solved

Dynamic constant line with line chart

Hello,

 

In line chart, Constant line can have a fix value not measure.

I need a line with dyanmice value  just  for line chart, and the measure is different from  the value of Y Axis.

There are two measures.

Measure1 is for Y Axis

Meausre2 comes from slicer and it will be just one line.

 

Thanks

Nicki

 

 

 

 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    You already have your measure, just add it to the values area of the line chart.

    • Nicki's avatar
      Nicki
      Icon for Helper III rankHelper III
      5 years ago

      I have already added it. The value of Line chart just accept one value, and there are two measures.

      I have legend because of this reason I cannot use the secondary Axis.

       

       

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Nicki ,

         

        One solution is to use multiple measures instead of ‘Legend’.

        Please refer to my .pbix file.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.