Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
vanessafvg
Super User
Super User

can line charts filter other visuals?

this is probably a dumb or hopeful question, but is there anyway to get a line chart to filter the other visuals in a dashboard?  i.e if i click on a point in  a line chart, when i hover over it, it shows me in the tool tip what date i am on, if i then wanted to filter the other visuals on my dashboard to see what events took place on that date by click on the chart, is that possible?  I cant use drill down because drill downs take away the exclude functionality which i need.  





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




1 ACCEPTED SOLUTION

@vanessafvg

 

Hi,

 

The line chart is a template which is already designed. It seems that we can't achieve this with the line chart, but we can try a custom visual though it isn't perfect. We can try the custom visual here: https://app.powerbi.com/visuals/. This one is recommended: https://app.powerbi.com/visuals/show/PBI_CV_25997FEB_F466_44FA_B562_AC4063283C4C It's not perfect. 

 

BTW, there is a line filtering idea you can vote:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13541385-line-graph-filterability

 

There is a similar post you can refer to:http://community.powerbi.com/t5/Desktop/Line-Chart-not-correctly-filtering-other-visualizations/m-p/...

 

can line charts filter other visuals..JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards

Dale

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

View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @vanessafvg,

 

You can have any visual/ chart to interact as a filter in your reports.

 

Please refer to the link below:

 

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11a-create-interaction-betwee...

 

Regards,

 

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



hi @MFelix

 

thanks for the response, i am aware of the edit interactions.   However specifically with the line chart you can click on other visuals and it will filter through to the line chart however, when click on a pointin the line chart, it doesn't filter the other visuals, edit interactions does show the filter which is enabled, however that doesn't have an impact.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg

 

Hi,

 

The line chart is a template which is already designed. It seems that we can't achieve this with the line chart, but we can try a custom visual though it isn't perfect. We can try the custom visual here: https://app.powerbi.com/visuals/. This one is recommended: https://app.powerbi.com/visuals/show/PBI_CV_25997FEB_F466_44FA_B562_AC4063283C4C It's not perfect. 

 

BTW, there is a line filtering idea you can vote:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13541385-line-graph-filterability

 

There is a similar post you can refer to:http://community.powerbi.com/t5/Desktop/Line-Chart-not-correctly-filtering-other-visualizations/m-p/...

 

can line charts filter other visuals..JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-jiascu-msft,

 

it seems that the link to the custom visual isn't working. Can you give me the name of the visual?

 

Thx!

 

Valérie

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.