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. 

3 Replies

  • Anonymous's avatar
    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?

     

    • m_alireza's avatar
      m_alireza
      Solution Specialist

      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?