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: -
First, we need to create a calculated table in which we need to define the data format.
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.
3. Apply your measure logic just like the below figure.
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.
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).
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.
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.
Instead of using a calculated table in step 1, is a regular table allowed too?
you should go more into depth like applying switch() so that you can output the different formats vs just 1 which could be done with out dynamic data types.