Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart with dynamic goal to compare

Hello Community, I need your help with a line chart.  What I have is a report with three elements: 1) map to select a country, 2) line chart  and 3) indicator slicer.   If I select a country one ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    I think you can use the bookmark function to make it.

     

    Create 2 charts and 2 bookmarks for each chart.

     

    And when you click the first value of the indicator slicer, do bookmark 1, show chart 1.

    click the second value to do bookmark 2 and show chart 2.

     

    And chart 1 and chart 2 can have a different constant line.

     

    Please try.

    Aiolos Zhao

  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    To make bookmarks work for every selected options, you may refer to the articles: Use bookmarks to share insights and build stories in Power BI , Dynamic Visuals using Buttons, pay attention to the detail.

     

    In addition, you may also create measure like DAX below to include the effect of slicer filter, and put the measure to chart line.

     

    Measure1= CALCUALTE(SUM([Value]), ALLSELECTED(Slicer[selection]))

     

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the advice. I tried it because it is simple, but it doesn't work. I have charts 1 and 2, one on top of the other and I replaced the slicer with 2 square shapes so I can assign each one a diferent bookmark. Bookmark 1 is when chart 1 is in the front, bookmark 2 is when chart 2 is in the front. The issue is that the charts don't switch between front and back.

 

I'm going to try the second reply I got, but thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You need to set "show" or "hide" for chart 1 and chart 2 for the different bookmarks, but not "front" or "back".

 

Then you will make it.

 

Aiolos Zhao