Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…
Data dictionary in Power BI by using Q&A, GIF background
Here is a fun way to use Q&A functionality to build a data dictionary in Power BI. The first question might be –…
How to connect to the Salesforce data with Power Query, Power BI, Excel
Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…
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…
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…
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…
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…
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…
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.…
