We’ve started the 9th leg of our Power BI Challenges, this time focusing on currency conversion.

While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don't want these users to refresh the data.

Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme & graphics, macros and do whatever you want. You can even generate a paginated report. Next time you will open this file from Power BI Sidetools, it will be refreshed and you will keep all the setup you did previously. Super quick and super efficient in few steps.

The conditional formatting feature in Power BI allows users to specify customized cell colors based on cell values, other values or fields by using gradient colors.