Power KPI Matrix_ Current Value Column

[Anonymous]

Hello there,

i have a question related to power KPI Matrix, how I can present different data types[%,$,#] in the same column "Current value column" and what is the data type of the actual data should be. 

Thanks,

TA

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You need to use conditional judgment function to create a measure.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , id at column or meausre is it changed by slicer ?

If it controlled by slicer, there was an option dicussed with external tool in this video : https://www.youtube.com/watch?v=vlnx7QUVYME

[Anonymous]

i need the current value column show the different data types as the following screenshot: