Implementing visual level filters using Dax in Power BI

Case- Observe the following screen shot.

In the above image I want to view the prices of the selected products but it is displaying all the column values from the price list in the multi row card where it should show nothing when nothing is selected from the product name.

Creating a dax measure which can ensure that the data set is filtered

Let us create a dax measure as following.

Only when filtered = IF (ISFILTERED (‘Product’ [ProductName]), "Y”, "N")

This dax measure ensures whether a filtering has happened. If so it returns “Y” otherwise it returns “N”.

Using the above created dax in visual level filter

The above dax measure is applied to the visual level filter of the multi row card as shown below. you can just drag and drop the measure to the visual level filter.

As you can notice I have used the above created measure “Only when filtered” to display data when it returns “Y”. In other words "Show items when the value contains Y".

This might seem a bit tricky but it is simple and very useful. We can state this as an advanced filtering where we are implementing a condition to show data simply we are filtering using an “If condition”.

Once I implemented this, the result is as expected and it’s shown below for each cases.

When nothing is selected.

When one product is selected.

When multiple products are selected.

Comments

Choosing color scheme for Power BI reports

Choosing beautiful colors for an attention seeking Power BI report is always challenging. Sometimes we may have an important message but it might go unseen if proper color scheme is not used, so it is important to create reports which are informational and visually appealing. In this blog our main objective is to get an idea about selecting appropriate color scheme and tools that can be beneficial to do this. What is a color scheme? As you all know not all colors look great together and you can tell stories by just having only two colors, have a look at the following image, there in the middle you can see a circle with same color and same dimension, only thing that changes is the back ground, but depending on the back ground the way you see those circles are totally different. Some small circles appear softer, some appear sharper, and some are brighter also you might notice movements or depth effect too. It is important to choose colors wisely to serve the purp...

Five tips to enhance a tableau model with usability features.

In the previous blogs I was more focused in Power BI since i work with it day to day, but this time we are going to dig into increasing the usability features of tableau. This blog revolves around the end-user simplicity, if a model is hard to comprehend then it will be a disaster, so we should deploy some means to stay simple. So without further ado lets head on to the first topic of the day. Configuring table and column properties. A model can consist of many tables but the important fact is they have to be unique and it is better if we can have a table description to elaborate on whats it about. This can be also considered as an internal documentation, when a project member is changed it is easy to pick up and continue. We use connections to load data for the tables and we have a connection name for it but once if we set the source it cannot be changed in the latter part, so be mindful because once you are dropping a connection you are losing all th...

Ragged hierarchy in Power BI

Case- I have a data set which has to be visualized in a ragged hierarchy. What is ragged hierarchy A ragged hierarchy is a user defined hierarchy with an uneven number of levels. You can see the above table which has 5 levels of hierarchy. In the first level we only have “World” as a category then moving forward to the next level we have two categories namely “UK” and “USA” likewise the level of hierarchy is drilling down up to five levels with an uneven amount of categories. Creating a hierarchy in Power BI In the above image you can notice that I have right clicked the “level 1” column which has to be the first level of our hierarchy, Once it is right clicked there you will notice “New hierarchy” as the second option then you will have to click that in order to create a new one. As you can notice in the above image once I have created a new hierarchy then a new column is created named “Level 1 Hierarchy” in that I have d...

Ajan's BI Blog

Search This Blog