Benchmark with line value based on slicer selection

[joep78]

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 the real data look likes. 

What I want to reach is the RED line, this line should be the value as shown in the table next to it. This is based on the filtered City via filter 'Benchmark reference'. This filter has no interaction with the other visual, same counts for the 'Relevant cities' filter, this has no interaction with the left visual. I thought that doing that, creating a measure, this will solve my puzzle but because of the missing interaction, no values are shown. Having interaction also results in failure. 

How should I approach this, I Want to be able to have a dynamic benchmark option but can't figure out how to solve this.

Hopefully somebody can help me out with this, thanks already for your attention!

Regards,

Joep 

[v-henryk-mstf · Accepted solution]

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]

@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.

[joep78]

 Hi Amir,

I did not get the result I wanted but I can share the file with you: https://1drv.ms/u/s!ApmuagLsUpWxqiGCpxbnKS-SU68g?e=BEC0ku

If you are able to solve this puzzle will save me a lot of time! Thanks already for your action!