Slicers are graphical objects that we can use to filter data on a Power BI report page. When we use the dates to create slicers, then we create the so-called Timeline slicer. Until now, we were able to manually select a date range to filter the data in the report, and recently it is possible to run a Date Picker control in order to chose a date within a slicer.
If you’re creating a Power BI report that consists of multiple pages, it’s a good practice to add a navigation menu to its header. Previously, this was achieved by adding multiple buttons, assigning links to each of them that lead to the corresponding pages, and then grouping them into a single menu. Today, there is a much simpler way to achieve this, and recently it is also possible to define a landing page.
When you define conditional formatting within a visual, there are several options available to you. You can apply a color gradient that formats the display from the lowest to the highest value, define formatting rules based on specified conditions, or use your own DAX formula to specify formatting conditions. In this article, you’ll learn how to apply conditional formatting by using DAX to achieve greater flexibility and control over how your report looks.
Power BI Desktop uses the currently active language settings (Settings/General/Language) when creating reports. If the report will be available to users who speak different languages, it is possible to implement multilingual support by defining appropriate translations. For visual titles and other key report elements, DAX formulas can be applied that use the USERCULTURE() function to automatically display content in the user’s language.
To forecast future trends, you can use the Excel Forecast Sheet option – it’s the fastest and easiest way to see what’s going to happen in the future based on historical data. It uses the FORECAST.ETS function which, in addition to calculating the trend, can also fill in the missing data or recognize the seasonality of the data, and it also uses the FORECAST.ETS.CONFINT function to calculate the confidence interval. How to make a forecast manually?