In one of the previous “recipes” you could find out what Power BI Workspace is. In short, it is a collection of datasets, reports and dashboards that we want to manage within the Power BI tenant of a company. When working with the service, there is a need for different users to have different levels of access to the content. In this text you will learn more about user roles …
When you create a dashboard within the Power BI service, you may want to be notified if the data reaches a certain predefined value. For this purpose we use Power BI Alerts, and one can only be created for Gauge, Card and KPI visualizations. In the following text you will find out how to use this Power BI service feature.
Sparkline is a chart that is located inside the cell and shows the change in value over a given period of time, and is suitable for observing trends. It can be a Column or Line chart. This way of presenting data has been in Excel since version 2010, and has recently become available within the Power BI Desktop reporting platform. In the text that follows, you will find out how it is added and changed …
In one of the previous “recipes” you could get acquainted with the EARLIER function. Here you could learn how to use this function to calculate the rank based on highest price of the product within a table. This can be done much more easily, by applying the RANKX function. Let’s see how it is used and what other options are also available when ranking data through DAX.
If we want to check, within the DAX statement, whether the element belongs to the given set we will use the operator IN and then, in the extension, in curly brackets, list the elements that belong to the set. In this way we can associate a filter within the CALCULATE function that specifies more than one value. A similar effect is achieved with the CONTAINSROW function.