Power BI – Ideal Visual Placement for multiple report elements

What we are going to explain below, is some basics when using Power BI so that you can place your visuals so that they all fit onto the screen.

Example: For our Example we are going to be using SCOM Data for SSAS Usage

  • Our requirement was to have ideally 9 charts on one Power BI page.
  • What we will explain below is what sizing we used and how we got it all to line up so that it was even.

NOTE: This does look to be a long blog post, but there are loads of pictures to explain, so it goes quite quickly.

  1. What you can see below is the final output, and we will explain how we got it all working:
  2. The first thing that we did was to get the right sizing for each of the report elements.
    1. We configured each of them by doing the following:
      1. Click on the report
        element.
      2. Then click on the Format
        Button
      3. Next scroll down to the bottom where it says General
      4. Now we configured our Report Elements with the following:
        1. NOTE: With the settings above, it will mean that we can fit in all 9 report elements.
      5. NOTE: If you have got a report element that is often on the right hand side of the report canvas and you try and enter a width where it cannot
        fit, you will see the following:
        1. What the above means is that it cannot expand to the desired
          width because there is no more space.
        2. As you can see above the report element is as far right as it can go.
        3. And there is a Red Box around the Width to show that it cannot expand.
        4. To get around this move the report element left, and then make the width change.
        5. This will also
          happen if you do this for the left, top and bottom.
  3. You can then go through and configure each of the 9 report elements as shown in step 3 above.
  4. In the next section below we will show you how to align all 9 reports for the Left, Center and Right
    alignment.
    1. NOTE: The easiest way that I found to do this was to do it in the steps below:
    2. First
      click on the report
      element that you want on the left
      hand side.
      1. Then in the ribbon click on Align and then select Align Left
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be left aligned
        2. Now click on the ribbon again and click on Align and then select Align Left
          1. This will then align all 3 report elements to the left hand side.
          2. NOTE: It appears that it takes the report element that is the furtherest left aligned and aligns the rest of the report elements to this.
        3. Here are all 3 left aligned
          1. NOTE: You will see that they are aligned to the left, but not correctly spaced from top to bottom, we will do this in the following steps.
    3. Next
      click on each of the 3 report elements that you want to be in the Center.
      1. Then in the ribbon click on Align and then select Align Center
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be Center aligned
        2. Now click on the ribbon again and click on Align and then select Align Center
          1. This will then align all 3 report elements to the center hand side.
          2. NOTE: It appears that it takes the report element that is the center aligned and aligns the rest of the report elements to this.
        3. Here are all 3 aligned to the center
          1. NOTE: You will see that they are aligned to the left, but not correctly spaced from top to bottom, we will do this in the following steps.
    4. Next click on each of the 3 report elements that you want to be in the Right
      1. Then in the ribbon click on Align and then select Align Right
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be Right aligned
        2. Now click on the ribbon again and click on Align and then select Align Right
          1. This will then align all 3 report elements to the right hand side.
          2. NOTE: It appears that it takes the report element that is the furtherest right aligned and aligns the rest of the report elements to this.
        3. Here are all 3 aligned to the Right
          1. NOTE: You will see that they are aligned to the left, but not correctly spaced from top to bottom, we will do this in the following steps.
  5. In the next section below we will show you how to align all 9 reports for the Top, Middle and Bottom
    alignment.
    1. NOTE: The easiest way that I found to do this was to do it in the steps below:
    2. First click on the report element that you want on the top
      1. Then in the ribbon click on Align and then select Align Top
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be top aligned
        2. Now click on the ribbon again and click on Align and then select Align Top
          1. This will then align all 3 report elements to the top of the report canvas.
          2. NOTE: It appears that it takes the report element that is highest and aligns the rest of the report elements to this.
        3. Here are all 3 top aligned
    3. Next click on the report element that you want on the middle
      1. Then in the ribbon click on Align and then select Align Middle
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be Middle aligned
        2. Now click on the ribbon again and click on Align and then select Align Middle
          1. This will then align all 3 report elements to the middle of the report canvas.
          2. NOTE: It appears that it takes the report element that is highest and aligns the rest of the report elements to this.
        3. Here are all 3 middle aligned
    4. Next click on the report element that you want on the Bottom
      1. Then in the ribbon click on Align and then select Align Bottom
        1. Then in order to get it done quicker, you can now select all 3 report elements that you want to be Bottom aligned
        2. Now click on the ribbon again and click on Align and then select Align Bottom
          1. This will then align all 3 report elements to the bottom of the report canvas.
          2. NOTE: It appears that it takes the report element that is highest and aligns the rest of the report elements to this.
        3. Here are all 3 middle aligned
  6. NOTE: You might have to play around with the elements to get them to where you want them to be.
  7. So now once this is all done you can see them all aligned as shown as with the original picture:
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s