Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Political Chart

Hi friends,

 

Unfortunately, I'm struggling while trying to recreate a parliament chart like the following one: 

 

The following links are not helping that much:

https://powerbi.microsoft.com/en-us/blog/politico-europe-bets-on-microsoft-power-bi-to-report-on-the-european-union-elections/

https://synoptic.design/

 

I know Deneb can make a real difference here as well, but I have no experience at all.

 

Any tips?

 

Thank you very much for your time.

BR,

Dan

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you very much for your help giammariam .

       

      Unfortunately, I'm facing some problems while trying to recreate the exact same chart. I've also tried SandDance but without success.

      Can you please take a look at the document?

       

      https://github.com/WabiSabi29/Tests.git

       

      Thank you once again.

      • giammariam's avatar
        giammariam
        Solution Sage

        Hey Anonymous, let me know if this is closer to what you're after. I'm not completely familiar with the dataset, but it appears a key difference between your dataset and PBI-David's is that he has a row for each dot, where your table is aggregated. That's why there were only 21 dots. I'm also not sure what the relationship between seats and mandates is, so if the label should say "Total Mandates", that's an easy fix.

         

        In Deneb I exploded your dataset using the sequence and fold transforms. 

         

        If you expect a different color scheme, let me know which parties should be associated to which colors.

         

        .pbix: https://github.com/Giammaria/PublicFiles/blob/master/PBI%20Community%20Help/Parliament%20Seat%20Projections.pbix

  • paulojorge1's avatar
    paulojorge1
    Frequent Visitor

    Hi Madison Giammaria 

     

    Thank you for your help. I realy apreciated you excelent job. it´s there a way to order the party in the parliament  seat ? for instance i like to have 1 PS and after all the left wing (B.E , PCP) and the same with PS/AD and the rest of all the right wing.