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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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