Techno Blender
Digitally Yours.

Bring life to Field Parameters in Power BI | by Nikola Ilic | Jun, 2022

0 89


Check this simple trick to enhance the user experience when using Fields parameter feature in Power BI

Image by author

To be honest, I can’t remember that one Power BI feature caused so much hype as the Fields parameter, which was introduced in the May Power BI Desktop monthly update! Ok, the MS Build event a few days later brought some extremely cool and appealing features, such as Datamart or PowerPoint integration, which pushed the Fields parameter aside, but still, I firmly believe that the Fields parameter is one of the things that will forever change the way we are building user experience in Power BI.

I will not go into detail about the feature itself, and how it works behind the scenes, as my fellow community contributors already did a fantastic job explaining it. I suggest you start reading this wonderful article from my friend Tom Martens, or if you prefer watching videos, this one from SQL BI guys.

Additionally, there are already some very creative use cases of this new feature, such as this one by Kane Snyder.

However, in this article, I wanted to give you a quick heads up on how you can leverage the Fields parameter to bring some additional life to your Power BI reports!

My data model is incredibly simple: I have one fact table and three dimension tables — region, product, and date.

Image by author

Let’s go and create field parameters for our data model:

Image by author

As you may notice, I dragged two columns from each of my dimension tables, and once confirmed, I have a new slicer on my report page, enabling users to slice and dice the data in many different ways. And, no complex DAX in the background is needed!

Image by author

How cool is that! However, what if we want to group Fields parameter values based on certain criteria. For example, all product-related fields should belong to one group, geography-related fields to another, and so on.

I have great news for you! But, before I show you how to do this, let’s take a look at the underlying DAX code that was automatically generated by Power BI while creating the Fields parameter table:

Image by author

As you see, it’s “just” DAX! And, once again, I’ll not go into detail, explaining the purpose of each code part, but understanding that this is “just” DAX opens up a possible room for customizing this table! So, let’s do this!

The idea is to group Brand and Category fields under one “umbrella”, Continent and Country under another, and finally Year and Month short name also under the third group. I can simply add a new column for each member of the DAX table definition, something like:

Image by author

But, I have a better idea! Let’s bring some life to this, and display icons instead of text! I’ll use a well-known UNICHAR() function to provide the numeric value that should be converted to an icon, similar to what I explained in this article.

Slicer = {
("Brand", NAMEOF('Dim_Products'[Brand]), 0, UNICHAR(127981)),
("Category", NAMEOF('Dim_Products'[Category]), 1, UNICHAR(127981)),
("Continent", NAMEOF('Dim_Region'[Continent]), 2, UNICHAR(127757)),
("Country", NAMEOF('Dim_Region'[Country]), 3, UNICHAR(127757)),
("Year", NAMEOF('Dim_Calendar'[Year]), 4, UNICHAR(128198)),
("Month Name Short", NAMEOF('Dim_Calendar'[Month Name Short]), 5, UNICHAR(128198))
}

This is the DAX code after I’ve added an additional column. And, I’ve also renamed the newly created column from generic “Value 4” to “Group”:

Image by author

It’s time to put our new setup into action! So, I’ll drag the Group column in the fields of the parameter slicer, just above the original Fields parameter values:

Image by author

Wooow! Now, my Fields parameter values are grouped under these nice icons, so my users can easily understand various slicing options! They can still quickly slice the data based on multiple different fields, coming from different groups, but the data is much better structured and organized this way!

Image by author

Let’s do some additional little magic to enhance the user experience even more!

I want to enable my users to choose on their own how they want to see the data in the matrix! In other words, to dynamically choose what is displayed in the rows vs columns!

I’ll go and create a duplicate of this Fields parameter table, but this time I’ll enable a Single select for my slicer, so that matrix doesn’t become too cluttered if nothing is selected:

Image by author

Awesome! Now, our matrix is fully customizable and users can dynamically choose how they want to see the data — switching between the rows and columns!

Fields parameter is one of those features you simply know will have a huge impact! Not just because it opens up literally an indefinite number of possible use cases, but also because of easy implementation and potentially extended customizations to answer business questions in a more efficient way.

Thanks for reading!

Subscribe and don’t miss any story on Medium!


Check this simple trick to enhance the user experience when using Fields parameter feature in Power BI

Image by author

To be honest, I can’t remember that one Power BI feature caused so much hype as the Fields parameter, which was introduced in the May Power BI Desktop monthly update! Ok, the MS Build event a few days later brought some extremely cool and appealing features, such as Datamart or PowerPoint integration, which pushed the Fields parameter aside, but still, I firmly believe that the Fields parameter is one of the things that will forever change the way we are building user experience in Power BI.

I will not go into detail about the feature itself, and how it works behind the scenes, as my fellow community contributors already did a fantastic job explaining it. I suggest you start reading this wonderful article from my friend Tom Martens, or if you prefer watching videos, this one from SQL BI guys.

Additionally, there are already some very creative use cases of this new feature, such as this one by Kane Snyder.

However, in this article, I wanted to give you a quick heads up on how you can leverage the Fields parameter to bring some additional life to your Power BI reports!

My data model is incredibly simple: I have one fact table and three dimension tables — region, product, and date.

Image by author

Let’s go and create field parameters for our data model:

Image by author

As you may notice, I dragged two columns from each of my dimension tables, and once confirmed, I have a new slicer on my report page, enabling users to slice and dice the data in many different ways. And, no complex DAX in the background is needed!

Image by author

How cool is that! However, what if we want to group Fields parameter values based on certain criteria. For example, all product-related fields should belong to one group, geography-related fields to another, and so on.

I have great news for you! But, before I show you how to do this, let’s take a look at the underlying DAX code that was automatically generated by Power BI while creating the Fields parameter table:

Image by author

As you see, it’s “just” DAX! And, once again, I’ll not go into detail, explaining the purpose of each code part, but understanding that this is “just” DAX opens up a possible room for customizing this table! So, let’s do this!

The idea is to group Brand and Category fields under one “umbrella”, Continent and Country under another, and finally Year and Month short name also under the third group. I can simply add a new column for each member of the DAX table definition, something like:

Image by author

But, I have a better idea! Let’s bring some life to this, and display icons instead of text! I’ll use a well-known UNICHAR() function to provide the numeric value that should be converted to an icon, similar to what I explained in this article.

Slicer = {
("Brand", NAMEOF('Dim_Products'[Brand]), 0, UNICHAR(127981)),
("Category", NAMEOF('Dim_Products'[Category]), 1, UNICHAR(127981)),
("Continent", NAMEOF('Dim_Region'[Continent]), 2, UNICHAR(127757)),
("Country", NAMEOF('Dim_Region'[Country]), 3, UNICHAR(127757)),
("Year", NAMEOF('Dim_Calendar'[Year]), 4, UNICHAR(128198)),
("Month Name Short", NAMEOF('Dim_Calendar'[Month Name Short]), 5, UNICHAR(128198))
}

This is the DAX code after I’ve added an additional column. And, I’ve also renamed the newly created column from generic “Value 4” to “Group”:

Image by author

It’s time to put our new setup into action! So, I’ll drag the Group column in the fields of the parameter slicer, just above the original Fields parameter values:

Image by author

Wooow! Now, my Fields parameter values are grouped under these nice icons, so my users can easily understand various slicing options! They can still quickly slice the data based on multiple different fields, coming from different groups, but the data is much better structured and organized this way!

Image by author

Let’s do some additional little magic to enhance the user experience even more!

I want to enable my users to choose on their own how they want to see the data in the matrix! In other words, to dynamically choose what is displayed in the rows vs columns!

I’ll go and create a duplicate of this Fields parameter table, but this time I’ll enable a Single select for my slicer, so that matrix doesn’t become too cluttered if nothing is selected:

Image by author

Awesome! Now, our matrix is fully customizable and users can dynamically choose how they want to see the data — switching between the rows and columns!

Fields parameter is one of those features you simply know will have a huge impact! Not just because it opens up literally an indefinite number of possible use cases, but also because of easy implementation and potentially extended customizations to answer business questions in a more efficient way.

Thanks for reading!

Subscribe and don’t miss any story on Medium!

FOLLOW US ON GOOGLE NEWS

Read original article here

Denial of responsibility! Techno Blender is an automatic aggregator of the all world’s media. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials, please contact us by email – [email protected]. The content will be deleted within 24 hours.

Leave a comment