Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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?

     

    • m_alireza's avatar
      m_alireza
      Solution Specialist
      3 years ago

      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?