Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Remaining original values when dynamically values changing

Hi,

 

I changed some setting mistakenly, after then values dynamically reflecting but doesnt show original values. 

I also changed some option and setting. 

 

 

Used to be: 

 

 

 

Now:

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    1 year ago

    Hi Anonymous 

     

    It's visual interaction. Select crosshighlight

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    Thanks again to ajaybabuinturi  and danextian for your time and suggestions

    Both super users provided valid solutions  your issue is caused by changes in visual interactions. To fix it.

    1. Select the visual (e.g., the map or chart).
    2. Go to the Format ribbon → Click Edit Interactions.
    3. On the affected chart (e.g., the bar chart), choose either:
      • No interaction (circle with line icon) to keep totals static.
      • Highlight to show filtered values while retaining totals.
    4. Exit Edit Interactions mode once done.

    If you're still facing issues, feel free to upload a sample .pbix file or share mock-up expectations.

    Regards,
    Akhil.

3 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Super User
    1 year ago

    Hi Anonymous, 

    Wanted to let you know that your question doesn't provide sufficient information. However I found(I believe) an issue that you clicked EDIT INTERACTIONS. If you want to turn off that select any visual >> go to format>>unselect edit interactions.

    More about edit interactions: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop 

     

    If you need exact solution try to provide some sample data of .pbix file and expected results mockup.

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi Anonymous 

     

    It's visual interaction. Select crosshighlight

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

    Thanks again to ajaybabuinturi  and danextian for your time and suggestions

    Both super users provided valid solutions  your issue is caused by changes in visual interactions. To fix it.

    1. Select the visual (e.g., the map or chart).
    2. Go to the Format ribbon → Click Edit Interactions.
    3. On the affected chart (e.g., the bar chart), choose either:
      • No interaction (circle with line icon) to keep totals static.
      • Highlight to show filtered values while retaining totals.
    4. Exit Edit Interactions mode once done.

    If you're still facing issues, feel free to upload a sample .pbix file or share mock-up expectations.

    Regards,
    Akhil.