cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andrmh Regular Visitor
Regular Visitor

Using a Line Chart to filter data

Hello all,

 

Searching seems to indicate this is a long standing issue, with the idea mentioned here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13541385-line-graph-filterability

 

Not sure what the state of things is with That idea posted 2 years ago.


But, I was looking for ideas or even a third party visual that perhaps may do the trick.

I have the following line chart:
LineChartSample.PNG

 

When I click on a Line, the filter applied to other visuals on the page, is the Legend value (say Alarm)
Ideally, I want it to be BOTH Alarm - July 2018 as an example.

 

Further, the line chart behaves differently to other visuals in a filter sense.

If I were to display the same chart as a Column chart, The X-Axis is applied as the filter, not the legend. To filter by the legend, You actually have to click on the legend item itself.

 

Why?

 

Why is the default filter value on a line chart the Legend, where almost everywhere else its the Axis?

 

Unless im doing something wrong The line chart appears to be one of the weakest visuals, dispite being so simple...

Does anyone know of a custom visual that may do the job for me? Even if atleast it were to follow the standard 'filter on axis' scenario this would be an improvement, I might be able to work around the rest.

 

Thanks.

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Using a Line Chart to filter data

@andrmh,

 

You may try using a slicer to filter data.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?src=office&tab=Overview

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
andrmh Regular Visitor
Regular Visitor

Re: Using a Line Chart to filter data

Thankyou for the reply, that is a useful filter visual, however using a filter as a solution isnt suitable.

 

The reason we use a line graph, is to visually represent movement over time.

Then, the reason we add the legend on category is to show volume based differences in said categories over that common timeframe.

 

If we were to add a filter, that point of comparison is visually lost.

- Filtering on date (or dates) will yield 'points' not 'lines' of movement.

- Filtering on category prevents the consumer of the report observing the differences in volume over time.

 

Lastly,

Our approach in simple scenarios (which this should be) is that the visual itself is the filter.

The user interacts with the plot, this will display a table of transaction details for their point of enquiry.

 

You can do this with Pie charts (though no via 2 different cross sections, time and category), Column graphs, maps.... near anything... BUT not line graphs.

This is a significant pitfall.

 

So much so that this is practically a bug, not a limitation. This visual simply behaves differently to the basic filtering every other visual applies.