Power BI Desktop: Print in the A4 size

Power BI Desktop: Print in the A4 size

As you know, the August 2018 update of Power BI Desktop grants us the possibility to export in PDF directly from the Desktop. Two clicks and it’s done. Great news right? I remember all the steps I had to go through to make it before, it still give me headache…

But by default, the report will be exported with the standard format of Power BI Desktop which can be for some end users or clients not very pleasant to read especially if they are used to an A4 page. The real question is then, how to export in that specific format? Here is the answer.

First, let’s take our wonderful LazyDAX file and create a new page. Here is the default view you have when adding a new page.

Nothing special until there. What’s interesting is the “Page View” button under the “View” tab. Once we click on it, we can select “Actual Size”.

By choosing “Actual Size” we will see the “real” size of the page, based on its dimensions.

Now we can see that the page size exceed the usual limit of the report. But we want to make it like a A4 portrait page right? So, we are not done yet. You can select the “Format” pane of the report page, then “Page Size” and select “Custom” as “Type”.  Now, we just have to enter the custom size we want. I chose 794*1123 pixels because it is the A4 size at 96 PPI (depending of the printing, you can find more info about it here).

Now we have our A4 report page ready to be filled.

As you can see, there is now a scroll bar on the right side of the report because of the dimension of the page. We now just have to export as PDF and that’s it. You can click on the “File” button and then choose “Export to PDF”.

You now just have to let Power BI make the work and here is the result.

The last report page is well in portrait format, while the others have been exported in the default format.

As you can see, there is nothing really difficult here but you just have to be aware of it.

 

Learn DAX from examples: Lazy DAX

Learn DAX from examples: Lazy DAX

Concrete cases in DAX

Working with Power BI (or SSAS Tabular) does not require much effort. It’s quite intuitive and easy to set up.
However, to fully enjoy it, it is recommended to take the time to learn DAX.

Create a measure, in the formula bar, is done through an expression written in this language.
Very powerful, the DAX contains some functions that will give all the interest to your beautiful data model.

It would be a shame to see him as a cherry on the cake! It would be rather a cherry cake over the cake!

Simple syntax, very powerful function in a few lines, but it can be complicated.

You will find here support with some concrete cases, from the simplest to the most complicated.

 

  • A Power BI Desktop file
  • A PowerPoint file with multiple explanations. You can use it to provide training or initiation to the DAX.

If you have new exciting measures, do not hesitate to send them (via LinkedIn), I will be happy to add them in the Power BI file.

 

My colleague Mathieu Ricour and myself are happy to share you another way to learn DAX.

In Lazy DAX, you will found:

A Power BI Desktop file

  • It contains multiple examples based on a simple and understandable set of data
  • With multiple clear examples, you can change the expressions / scripts and directly see the result. (It will help you to understand and develop in DAX)
  • For now it covers:
    • The basics functions (COUNT, DISTINCTCOUNT, SUM, …)
    • CALCULATE function
    • Time Intelligence
    • Semi Additive measures
    • Calculated Columns
    • Rank
    • EARLIER
    • Variables
    • A concreate example: Churn Rate

A PowerPoint file

  • In this power point we provide you some explanations to learn step by step.
  • You can use it to understand the basics (maybe give you a first view of what you can do with DAX and Power BI)
  • If you have to prepare your own DAX training, it could be a starter.

 

Our files are available for download on GitHub

https://github.com/arnaudgastelblum/LazySnail

Pin It on Pinterest