Dynamic Data Type in PowerBI

By Ashish Kumar

In this article, we will see how we can use dynamic data type feature in Power BI.

Before we dive into this, let us understand what a dynamic data type is? and what it can be used for?

Dynamic data type is a data type format option by which we can show the values generated by the measure into two or more different data types dynamically.

Steps involved in implementation of Dynamic data type: -

1. First, we need to create a calculated table in which we need to define the data format.
   

calculated table

2. After creating the table, we need to create the measure with dynamic data type selection. Click on “New measure” option from the Home ribbon.

Measures

3. Apply your measure logic just like the below figure.

DAX

4. After writing the logic, please click on dropdown box of the format option and click on “Dynamic” data type, as shown in the below snapshot.

Data Type

5. The moment when you select the Format as “Dynamic”, you can notice that there is a list-box appearing (also visible in above snapshot).

Measure List box

6. After that please click on the dropdown of the list-box and select format option, we need to specify the format of data which is not available in the Table Format so that, we can provide the alternate result.

Format List box

Alternate data type result

Now, you can see dynamic data type in PowerBI. In our case, which is a numerical and a percentage value.

In case of any questions, please add your comments and stay tuned !! for our next upcoming exciting Power BI articles.