In this post I would like to explain more details about Power BI Designer features. In the previous post you learnt how to create some very simple reports. However, those reports were just for testing general features of the tool. For instance we didn’t even play with very simple features like renaming the dimension or fact tables and members to user friendly names. In this article not only do I explain some of the simple ones, but also I’ll go through some of the more advanced ones.
Again, as per my previous post, I’m using AdventureWorksDW2012 as a source database. We imported “Internet Sales” into the designer and we created some reports and one new page and we saved the reports on disc. So we have all the requirements on hand. Let’s go…
Making names more user friendly:
- Open the *.pbix report file in Power BI Designer
- Double click on “DimCurrency” to rename it to “Currency”. We need to do the same for all other objects
- We also need to do the same for the fields which are getting used on the reports