Forum Discussion

Vetinari's avatar
Vetinari
New Member
4 years ago
Solved

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...
Need Help
  • lbendlin's avatar
    lbendlin
    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Vetinari ,

 

You can try to create a disconnected table as a slicer, and then created a switch measure to show the different measures by slicer.

You can also use the Tabular Editor to achieve this.

Please refer to this blog:

https://community.powerbi.com/t5/Community-Blog/Using-a-slicer-to-show-different-measures/ba-p/1724504 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Vetinari's avatar
    Vetinari
    New Member
    4 years ago

    Thanks! But that would still mean that I can show only one measure in the clustered column chart at a time, right?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      No, you can have multiple measures.