Forum Discussion

Nicki's avatar
Nicki
Helper 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 ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    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.

     

lbendlin's avatar
lbendlin
Super User
5 years ago

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

  • Nicki's avatar
    Nicki
    Helper 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
      Community 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.

       

      • Nicki's avatar
        Nicki
        Helper III
        5 years ago

        Thank you for sharing your soultion.

        It works fine if there is a fixed number of CountryRegion.

        For example, if there are 1500 CountryRegion we need to create 1500 measures.

        Am I right?

        It does not work for me because my data or CountryRegion is not a fixed number and it will be changed every day.

         

        Nicki