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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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