Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to bring a chart front when filter selection changes

Hi all,   I have a line chart, on top of this line chart i have added a message created out of single card visual which shows a message "Select the current year" when any year other than the curren...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous I believe you would have to use bookmarks and buttons for something like this.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak  Greg_Deckler 

 

Hi both, Thanks. 

 

Infact, i have 3 visuals on top of each other. 

1. actual

2. forecast

3. tranparent visual which pops up when year selected other than the current year.

 

Im already using a button to toggle between "Actual" and "Forecast".

 

So in this situation how can i make the Transparent visual go back of the Forecast chart when year 2020 is selected and bring forward when any other year is selected. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous You would have to have a button for 2020 and additional buttons for your other years. No clean way that I can think of.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    AFAIK, current power bi does not exist similar features to affect the visual layout level.

    In my opinion, I'd like to suggest you take a look at the following link to create a dynamic attribute filter with direct interactions with your record graph instead of creating multiple visuals and change their layouts based on filters.

    Dynamic Attributes In A Power BI Report 
    Regards,

    Xiaoxin Sheng