Forum Discussion

joep78's avatar
joep78
Helper III
4 years ago
Solved

Benchmark with line value based on slicer selection

Hi all,   I'm looking for a solution for benchmarking sustainability data, best way to explain my issue is via a image:     The data set I've created is ofcourse a simple extraction of how...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi joep78 ,

     

    According to your description, the dynamic baseline may change dynamically depending on the slicer.

    If you use the tooltip function and add the measure in, the display is not intuitive. Therefore, we suggest to set the baseline manually by putting the sum value corresponding to the city selected in the slicer into the card, and set the baseline manually in Analytics->Constant line according to the card.

    The reference is as follows:

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

amitchandak's avatar
amitchandak
Super User
4 years ago

joep78 , are you creating a measure like below for benchmark ?

 

 

Calculate([Measure], allselected(Table) )

With interactions on

 

 

if this does not help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.