Forum Discussion
FORMAT function not working in line charts
- 8 years ago
Hi Eric,
I'm afraid there isn't a good solution for now. Please refer to this post.
Best Regards,
Dale
Hi Anonymous,
That's because the measure return a non-numeric value which can't be added in the "Values" of the line chart. How about use the built-in currency format?
Best Regards,
Dale
Hi v-jiascu-msft,
thanks for your response! Unfortunately, I can´t make use this functionality because in my specia use case the format is determined by the underlying data source and may not be changed within PowerBI. But even if this was possible, I don´t think that I´d reach my goal of changing the currency format dynamically by doing so since you can only pick one currency at a time. Please correct me if I´m wrong with this.
The solution I´m looking for should allow for a dynamic change from e.g. € to $ etc.
I find it somehow strange that metric whose calculation I posted works in tables and even in tooltips of line and bar charts but not as th "values" of either line or bar chart. Doyou have any further ideas on this?
Best,
Eric
- v-jiascu-msft8 years ago
Microsoft Employee
Hi Eric,
I'm afraid there isn't a good solution for now. Please refer to this post.
Best Regards,
Dale
- Anonymous8 years agoNot applicable
Hi Dale,
it´s not the solution I was hoping for but was already afraid that it might not be possible to do what I intended...
Thanks for your efforts anyway!
Best,
Eric