Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

2 Stacked 100% Chart

Hi,   Is it possible to create 2 100% Stacked Chart side by side? I tried to use the default 100% stacked chart but it won't let me bring the 2nd values. So I am looking for something like this:  ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Thanks for providing the data. This turned out to be more difficult than I initially thought. I built in one way with Charticulator and two ways with Deneb. I had to learn a few new things for the Deneb ones, so it was time well spent (and good content for an upcoming video). Below are two screen shots, and attached in the pbix file so you can get the code (if you like one of the version). They all could use some more formatting, but the harder parts are done.

     

    Charticulator

     

    Deneb (approaches with "fold" and "repeat"/"layer" look the same)

     

    Pat

Anonymous's avatar
Anonymous
Not applicable
4 years ago

mahoneypat I will check it out. Looks like there will be a learning curve for that. So nothing which is readymade...right?Do you think any custom visual can do the trick? I tried on Appsource but couldn't find any.

 

Thanks for your help,

RK

mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

Not aware of an existing visual. However, this would be straight forward to make with the Charticulator or the Deneb visual. Both have some learning curve, but neither are steep. If you get stuck, @ mention me and I can provide a "template" or "spec", respectively, you can import.

 

Pat

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      4 years ago

      Thanks for providing the data. This turned out to be more difficult than I initially thought. I built in one way with Charticulator and two ways with Deneb. I had to learn a few new things for the Deneb ones, so it was time well spent (and good content for an upcoming video). Below are two screen shots, and attached in the pbix file so you can get the code (if you like one of the version). They all could use some more formatting, but the harder parts are done.

       

      Charticulator

       

      Deneb (approaches with "fold" and "repeat"/"layer" look the same)

       

      Pat

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        mahoneypat That's pretty good. What's the best way to re-produce it? Is there any way to copy paste the final graph?

         

        If I have to do it from scratch then I am trying to follow the steps:

         

        1. I created all the measures.

        2. Started with Mark on the glyph.

        3. Added Shape 1, looked at the attributes, put in text. Copied the attributes and then I got lost....lol

        4. I believe I need to add Shapes.

         

        Anyways, can 

         

         

        If the graph is not copy-able then can you tell me broad strokes like - 

         

        Step 1 : Get Mark

        Step 2: Get guides figure it out

        Step 3: Put text...something like that?

        so I can try to figure out myself?

         

        But thanks a lot, as always. You have always been a life saver. Only this Charticulator or deneb pieces require more learning and not very straightforward. 🙂

         

        I haven't checked the Deneb piece yet but will eventually be learning that.

         

        Thanks,

        RK