Forum Discussion

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

Measure to Covert a Measure to a Constant Line

Good Evening, Have been struggling with this one for a while.  Reaching out to the Forum for additional help.   I have the following measure which is calculated based on User selection from a date...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi rsbin ,

     

    You may select on this chart visual, go to Analytics pane ->Average Line, put the [Benchmark] into Measure box, and set it more like below.

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi rsbin ,

 

You may select on this chart visual, go to Analytics pane ->Average Line, put the [Benchmark] into Measure box, and set it more like below.

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
6 years ago

Hello v-xicai 

Thank you for this suggestion.  As noted earlier in the thread, this is the best solution that I have come up with thus far.

I have tweaked it slightly to use a Card to show the correct data value, as the Average value is not as accurate.

Appreciate you taking the time to respond.

 

Best Regards,