Dynamic Number Format

Rokie_101 — Wed, 17 Aug 2022 15:32:49 GMT

Hi Everyone,

I hope you're all doing well.

May I ask your help on how can I apply dynamically the format function with my existing formula.

Objectives: I want to format some of the selected value as "Percent", "Whole number" and "Decimal".

Existing formula:

AGENT LEVEL METRICS =

SWITCH(TRUE(),

(SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "ATTENDANCE RATE", [Attendance Rate],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "UTILIZATION", [UTILIZATION],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "PRODUCTIVITY", [PRODUCTIVITY COMPLETED SCORE],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "PROD RATE", [PROD RATE],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AHT ADHERENCE", [AHT ADHERENCE SCORE],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AGENT PRODUCTIVITY", [AGENT PRODUCTIVITY SCORE],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "QA REGULATORY MISSED", [QA REGULATORY MISSED],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "QUALITY", [QA PASS RATE],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "TOP ERRORS", [TOP ERROR],

SELECTEDVALUE('INDEPENDENT TABLE'[METRICS]) = "AGENT PASS RATE", [AGENT PASS RATE SCORE])

The following are the selected value that I want to dynamically change with its respective format.
[Attendance Rate] as a "Percent"
[UTILIZATION] as a "Percent"
PRODUCTIVITY COMPLETED SCORE] as a "Percent"
[PROD RATE] as a 2 "Decimal"
[AHT ADHERENCE SCORE] as a "Percent"
[AGENT PRODUCTIVITY SCORE] as "Percent"
[QA REGULATORY MISSED] as a "Whole Number"
[QA PASS RATE] as a "Percent"
[TOP ERROR] as a "Whole Number"
[AGENT PASS RATE SCORE] as a "Percent"

Thank you in advance.

Re: Dynamic Number Format

amitchandak — Wed, 17 Aug 2022 15:56:04 GMT

Rokie_101 , I would suggest using field parameters for this case

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

topic Re: Dynamic Number Format in DAX Commands and Tips

Dynamic Number Format

Re: Dynamic Number Format