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

Question

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).&nbsp; Is this possible to do? Ideally it could show more than one line at once so you could compare the data.&nbsp;

m_alireza · Answer

Anonymous&nbsp;,&nbsp;Would a field parameter work in your case?&nbsp;see here:Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft LearnHard to tell as I dont have much to go on in terms of what data you want to show.&nbsp;

anonymous · Answer

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?&nbsp;

m_alireza · Answer

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

Forum Discussion

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

Related content

Dynamic Status Change for events based on selected date range

Dynamic change of Default Slicer selection

Dynamic images based on selections

Change in category selection changes selected subcategory in slicers

Dynamic Filtering based on date selection