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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Buzz0m
Regular Visitor

Visualisation (line chart) filter not working? Limited amount of series?

Hi,

I have a line chart which is supposed to visualize a 190kdatarow set of data (y: numerical value, x: time). I want to filter the data with multiple filters, but when I'm applying the filters it seems that some of them aren't honoured and the data is missing from the visualisation itself.

 

What am I doing wrong?

Is there a limit to how many filters can be applied?

Is there a limit to how many series can be shown?

 

Below are a few pics, in which the data is first filtered with the filter "Juna_ryhmä" having two applied filters (all good). When I apply the third filter the previous filters are supposedly still aplied, but only the data which fits the last applied filter is shown...

 

pic2pic2

pic1pic1

 
1 ACCEPTED SOLUTION
Buzz0m
Regular Visitor

...aaand with the right google search I might have found the reason to my problems. There are limits to how many series one can display as well as how many datapoints can be displayed. Infuriating, that this isn't something that pops up as a warning in a visual...

 

https://docs.microsoft.com/en-us/power-bi/desktop-high-density-sampling

View solution in original post

4 REPLIES 4
Buzz0m
Regular Visitor

...aaand with the right google search I might have found the reason to my problems. There are limits to how many series one can display as well as how many datapoints can be displayed. Infuriating, that this isn't something that pops up as a warning in a visual...

 

https://docs.microsoft.com/en-us/power-bi/desktop-high-density-sampling

@Buzz0m hey sorry for the late reply, you already have a solution, let me know if I can still assist with anything. Good luck.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thank you @parry2k for taking the time to answer! As you mentioned I seem to have found the explanation to my problems so I marked it as the solution (it's sooo rewarding to mark your own answer as the solution...;) ).

Buzz0m
Regular Visitor

Aargh... I see this forum is flooded with help requests quicker than the world in a certain biblical story...

 

In hopes of getting some forum superhero to help I'm gonna tag @parry2k  in hopes of getting some attention 😃

 

Sorry for being desperate and hopefully thank you! =/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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