Forum Discussion
Vetinari
4 years agoNew Member
Dynamic Clustered Column Chart
Dear Community, in my project, I try to compare the cost structure of a product portfolio. There are 30 products in my portfolio (Prod. 1,..., 30), each of them belongs to a certain product categ...
- 4 years ago
Have you considered using Calculation Groups for that? They come with a cost (no pun intended) - You would have to learn how to use Tabular Editor. On the other hand they seem to fit your need perfectly.
Vetinari
4 years agoNew Member
That was a great hint! Thank you! Calculation groups significantly reduce the number of measures. But still I can only compare one type of cost in one clustered column chart. PowerBI won't allow me to add another measure into the values field.:
Is there some kind of work-around?
lbendlin
Super User
4 years agoYou can either have a legend or multiple values, not both. There may be custom visuals that support that.