Mykhael's avatar
Mykhael
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

Facebook Power BI Report

Facebook is one of the most important channels on social media for to many companies. But handle all the Data that Facebook give you by its API is very hard and sometimes confusing, but in this inter...
Social Media
tanckc's avatar
tanckc
Regular Visitor
10 years ago

Hey Mykhael

 

great work - how do you get he rounded edges on your charts and cards?

 

Best - [email protected]

  • Mykhael's avatar
    Mykhael
    Icon for Kudo Kingpin rankKudo Kingpin
    10 years ago
    Hi tanckc,
    The trick is very simple, those rounded squares are just that.... 1. Select shapes from the top panel. 2. Choose the square shape. 3. Select edit from the right panel (the icon is a little yellow pencil) 4. Go to General. 5. Change the rounded number. And that's it. You can change the line and shape color as well. Then you can overlay a chart or card to create the effect... If this answer helped you please give me a like and mark this answer as solution to help others. If you are interested in more tricks like this I invite you to check my posts here into the showcases, or you can email me and I can invite you in one of the conferences I speak about designing Power Bi reports. [email protected]
    Best
    • chonox's avatar
      chonox
      Frequent Visitor
      10 years ago

      Hi Mykhael, congrats on that spectacular FB report!

      Iam assuming that you are not using the FB connector on the power bi sources, right? Are you using fb page stats and loading it to a Database? Is it possible using power bi connector to build a report similar to yours?

       

      Thanks! 

      • Mykhael's avatar
        Mykhael
        Icon for Kudo Kingpin rankKudo Kingpin
        10 years ago
        Hello chonox,

        What you are assuming is correct!!! This particular report is connected directly to the Facebook API, and works LIVE, that means the information always change and get refreshed... The API send the data to my server in different tables (I use Azure) and then I use Power BI to manipulate and enhance my queries. About the Facebook connector you are talking about... In my experience is terrible, I don't think you can get a good report from that one... Maybe in the future they will improve it but right now it is very hard to use it.

        Best
    • vanessa's avatar
      vanessa
      Icon for Post Patron rankPost Patron
      10 years ago

      I tried this. But I am not able to see any option for rounded number. I can only see X Position, Y Position, Width, Height.

      • Mykhael's avatar
        Mykhael
        Icon for Kudo Kingpin rankKudo Kingpin
        10 years ago

        Hi vanessa,

         

        It is very easy, let me explain you.

         

        1. Select the shape

        2. Go to the Format Shape Panel (it's in your right)

        3. Select "Line"

        4. change the "Round Edges" Percentage

         

        That's it...

         

        I hope this helped you, anything else let me know OK?