Category: Power BI
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…
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.
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.
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.
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.
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.
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.
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.