Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have created unpivot column 'Value' of two columns - Amount and Count in power BI.
Measurement Value
Amount 135
Amount 1000
Count 1
.
.
.
I want to change the formatting of the column value depending upon if it is amount or count.
For example, 135 should be displayed as $135 and count should be just a whole number.
Are there any ways to achieve this?
Solved! Go to Solution.
You can not have different datatype or format for a single column. However, if you want just the currency sign to be displayed for Measurement = "Amount", then you can try the following steps:
1. Change the datatype of your Value column to Text
2. Then create a new calculated column using the following DAX:
You can not have different datatype or format for a single column. However, if you want just the currency sign to be displayed for Measurement = "Amount", then you can try the following steps:
1. Change the datatype of your Value column to Text
2. Then create a new calculated column using the following DAX:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |