Link a Visual to a Selection and Default Selection from a Visual

[Anonymous]

Hi there!

I would like to know how to relate a visual to the selection of another visual, for example, I have a visual line that shows the performance of a group of computers installed over a month, as a tooltip the amount of computers installed and running every day.

On the other hand I have a visual Gauge that shows how many computers are working as a value and how many are installed in a day as a maximum value.

My problem is that, with the configuration that I have just said, the visual gauge shows me the sum of the computers running every day as a value and the sum of all the computers installed as a maximum value, which is not a relevant data seen from that way.

I have tried relative date filters but these alter the line graph and focus it on a single day.

What I want is, to be able to have my line visual showing the performance of the computers every day of the month and that the last day is selected by default (today for example)

and also that the visual Gauge is updated with any day you select in the line visual.

Please watch the attached image.

I understand that it could be solved if the last available day was selected by default in the line graph but that the graph continues showing the rest of the month and not a single day.

[v-gizhi-msft · Accepted solution]

Hi,

Please check my attached pbix file.

Hope this is what you want:

Best Regards,

Giotto

[Greg_Deckler]

Perhaps use the relative date filters but Edit Interactions to not impact the line visual or just implement on the gauge visual. It is hard to tell but should be possible.

[Anonymous]

Sounds good @Greg_Deckler  but, can you explain me how can i edit interactions?

[Greg_Deckler]

Select a visual, Format tab in the ribbon, Edit interactions.

First result from: https://www.bing.com/search?q=power+bi+edit+interactions&form=ANNTH1&refig=c7063f31be3d4514824b47391...

is this article:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions