Forum Discussion

Nicki's avatar
Nicki
Icon for Helper III rankHelper III
6 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
    6 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.

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 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
Icon for Helper III rankHelper 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