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.
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,
5. The moment when you select the Format as “Dynamic”, you can notice that there is a list-box appearing
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.
