Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration, I found Power Query very useful. There is no difference if you are using Power Query in Excel or Power BI. The steps to connect to the data with Power Query are… Continue reading How to connect to the Salesforce data with Power Query, Power BI, Excel
Category: Power BI
Add custom button with a shortcut to Excel file in Power BI report
When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file in the Power BI report. This approach will work if the location of your Excel file is in OneDrive, SharePoint, and Power BI report user can access it. Other scenarios I will… Continue reading Add custom button with a shortcut to Excel file in Power BI report
Power BI chart with the accented gap between two lines
Here is how to create a Power BI chart with an accented gap between two lines. With the help of fill color between two lines, it will help you evaluate the difference between two values.
Color picker for Power BI or Excel
At this moment, there is no built-in color picker in Power BI or Excel, but here is how to use eyedropper PowerPoint. Eyedropper in PowerPoint is capable of detecting RGB and Hex color codes.
Power BI line chart that conditionally changes formatting
Here is how to create a Power BI line chart that at some point continues in a different design, formatting. For example, it is useful to continue actual data with the forecast but in a different style. In a way, it is conditional formatting for the line chart series in a Power BI.
Last available column value in Power BI
Here is how to detect the last available column value in Power BI in almost any situation. The main problem is columns with missing values in one or multiple places. But if your data contains something that represents a sequence, for example, date or index column, there is a simple solution.
Control Power BI DAX measures with a slicer
It is easy to control Power BI DAX measures with a slicer and turn them on or off for visualizations or other purposes. Here is how to do that in 4 easy steps.
Correct age calculation in Power Query
It is not so easy to do age calculation in Power Query in a way that works all the time correctly. There are useful transformations that calculate age, but in specific situations, it is not working properly.
How to connect to Power BI dataset with Excel
Here is one of the easiest ways to connect to the Power BI dataset with Excel to use it in PivotTable. First of all, you or other users should have access to the dataset. If you are the owner of the dataset, then that is not a problem but might be necessary for others.
Get the first and the last date of the week with DAX, Power BI
Sometimes it is necessary to get the first and the last date of the week with DAX to create additional information in the tooltip, filter only full week periods, use weeks for continuous chart axis, etc.