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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

How to dynamically change data shown on line graph based on user selection

I'm hoping to create a line graph that changes what data is shown based on user selection. I originally tried using bookmarks and buttons but the graph uses a significant amount of data points that caused my PowerBI to crash when I made 16 separate graphs (There are 16 columns).  Is this possible to do? Ideally it could show more than one line at once so you could compare the data. 

3 REPLIES 3
Anonymous
Not applicable

Thank you for the help, I was able to get the field parameter to work, but it shows the count rather than average of the data I have. Since my data is a different value each day this comes up as a horizontal line. Is this because I have too much data?

 

Hi @Anonymous , unfortunately, without seeing your data model/measures, etc,  I cant do much in terms of troubleshooting. 
Is it possible to send a sample pbix file so I can see the problem more clearly? 

m_alireza
Solution Specialist
Solution Specialist

@Anonymous , 

Would a field parameter work in your case? 

see here:
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Hard to tell as I dont have much to go on in terms of what data you want to show. 

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors