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.…
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…
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…
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…
