Filter time based on click

[TimGab]

I have multiple charts: one line chart and some other ones. The x-axis of the line chart represents values of time. All the charts are based on the same set of data. I now want to filter the other charts based on the point of time which I click on in the line chart. Is that possible?

[ankitpatira]

@TimGab to be able to do that click on the line chart and on top of power bi desktop click Visual Tools -> Edit Interactions. Then all other visuals that you want to filter simple choose filter icon for those visuals.

[TimGab]

thanks for the answer and visualization. that generally works (I tried it with other charts), but for some reason it won't work with that one line chart. I think that it might be becaused this chart is based on a time variable but I honestly have no idea why it wont work.

[Anonymous]

Hi @TimGab,

How do you create Line Chart in your scenario? Based on my test, the issue has nothing to do with time variable. In order to filter other visuals based on the point in Line chart, you will need to add Legend to the Line chart. When you click the point in Line Chart, it will filter other visuals according to the category in Legend. Otherwise, you will not able to click Line chart to filter other charts.

Thanks,
Lydia Zhang

[TimGab]

Hi Lydia,

thanks for the answer. That worked when recreating the issue with an MVP. But in my MVP I used a single (basic) column as values and in the actual case I used five calculated columns. For the actual case I can't even drag anything into the "legend" category.

The actual case consists only of the time variable in the axis category and the five calculated columns in the value category.

Another error that might be related: whenever I want to choose the time hierarchy I can only select the year in the hierarchy:

here one example from the MVP I created. Also: the MVP only works if I set the legend to the option that is not the hierarchy one. But then the line chart only displays individual points which is undesirable. 

Thanks in advance for the help.

Tim Gabriel

[Anonymous]

Hi @TimGab,

Could you please share sample data or PBIX file of your scenario?

Thanks,
Lydia Zhang