Forum Discussion
Charting problem exchange rates
Hi there, thank you for your reply!
I'll play around with that idea, but I am certain the underlying data (apart from the exchange rates themselves) is identical, so for each date the is a rate. Even if I throw away the second chart, change the page filter to only "USD", and afterwards put the currency data field in the legend, the same happens...
I would have expected the series line to remain the same and only for a legend to show up showing the currency name. But no luck. Any thoughts?
Maybe: Is my data table "structured" incorrectly?
I don't think changing the model is going to help you with the error message (I just tried creating a proper dimensional model with a star schema structure with Currency and Date dimensions, and still got the same error).
I think it has got to do with the fact that Power BI can only take around 1000 points (I think that is the limit) currently, and even if you are putting a filtered attribute (like currency), it would still calculate the number of points based on what the unfiltered list looks like. For eg, in your case, there are 31 values for curency and around 35 dates in the line chart (ideally you should have much more dates, but only 35 are appearing).
Hopefully this will change in the future, as was told by Will T from Microsoft Power BI team.
http://community.powerbi.com/t5/Desktop/Too-many-values/td-p/2939/page/2