This post is also available in: DeutschDeutsch

Change slicer from OR to AND logic in Power BI

image 1
This post is also available in: Deutsch In Power BI, slicers generally have OR logic implemented. This I normally also exactly what the user wants to happen. If I select the years 2021 and 2022 in a slicer, then I would like to see the values in the result which are either related to the year 2021 or to the year 2022. OR logic not always the correct one Sometimes, however, there are situations in which this is not the desired behavior. Let’s say we want to identify customers who bought “Product A” while also buying “Product C”. In such a case, I would like to select both products in the slicer. As a result, only those customers who have purchased both products should be displayed in a table.For such a case I need an AND logic for my slicer. In principle, the logic of the slicer cannot be changed. But I can create an AND logic with a measure and then either return only the desired result or filter a visual with the measure. Example Scenario – Which Lord of the Rings character got which weapons As today’s example, let’s take our characters from Lord of the Rings. […]
This post is also available in: Deutsch It was already announced since the end of 2020 that there would be an update in Power BI Premium capacities. After being in preview for some time, “Generation 2” or “Gen2” short, as the new version is called, is now generally available. But what is the difference to the current Power BI Premium and what is going to change? What exactly is Power BI Premium Gen2? Gen2 is a re-architecture of the existing Power BI Premium capacity. This redesign results in a few changes that are important for the end user and the administrator of the Premium Capacity. The previous Power BI Premium capacity was the same as renting a physical server. For example, when I rented a P1 capacity, I would get 8 CPU cores and 25 GB of RAM, which were reserved exclusively for me. As a result, I reached the limits of my rented server quite fast. For example, when all my datasets together exceeded 25 GB of RAM or my calculations exceeded the capacity of 8 CPU cores. Gen2’s concept is more like a software as a service approach. Now all capacities run on regional clusters, where all […]
This post is also available in: Deutsch Last week, a colleague at work had an interesting question with a customer. This wanted to perform a calculation with CALCULATE, but only on the records of the table where a measure has a certain value. Or in more simple terms, he wants to filter the table by a measure and then perform the calculation on the filtered table. Measure always requires filter context A characteristic of measures is that they always require a filter context. To make a simple example, if my Measure has the formula Sales Amount = SUM( myTableem, [Sales Amount]) , then this formula needs a filter context. Do I want the sales numbers per product or by year? Or maybe by country or by customer? All these issues can be solved with the formula just mentioned, but the result depends on the filter context. Best product by category For this scenario, I would like to use a simplified example. We assume I have different fruits and they are divided into color categories: Color Product Green Kiwi Green Avocado Orange Orange Orange Mandarin Orange Peach Red Apple Red Cherry Yellow Banana Yellow Lemon Of course, I am interested […]
This post is also available in: Deutsch An overlooked, but even more important topic in IT in general, but also in the area of business intelligence, is to make programs, or in our case reports, accessible to as many people as possible. What are the different types of barriers? Although there are other barriers, we will focus primarily on two areas. On the one hand visual, on the other hand physical limitations. Visual limitations When it comes to visual limitations, many people first think of blindness. However, there are significantly more types of visual limitation. Probably the most common is the red-green color blindness, which is estimated to affect nearly 10% of all people. There are also other limitations, such as problems with low-contrast content or limited ability to see. People who have problems in these areas can definitely be helped. Be it with a conscious choice of colors and high-contrast combinations. But also screen readers can help affected persons by reading the particular content to them. Physical limitations In addition to visual impairment, physical limitation is also common. These can be fine motor disorders or have a disease-related cause and simply mean that people have problems guiding a […]
This post is also available in: Deutsch Recently, I had received several questions about whether you can view a website directly in Power BI. This can be implemented quite easily and is a good way to add more information to a report. However, one restriction must be mentioned in advance. Unfortunately, Power BI Desktopdoes not load web pages, so we will focus on the Power BI Service here. But as a final result, here’s what we can look forward to: Loading via iFrame with HTML5 Visual In order to be able to load a website into our report, we must first ask ourselves which visual this can be done with. Here the HTML5 Viewer visual is very useful, with which we can display HTML code in a visual. In HTML itself there is then the iFrame tag, which allows to embed another website into your own website – or in our case into our Power BI Visual. This combination allows us to embed a website directly into a Power BI report.But the website author can prevent the website from being included via iFrame. For example, YouTube and Google prevent embedding via iFrame. In this case, simply no content is […]