https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4609012#M176434 <P>Dynamic formatting</P><P>See this <A href="https://youtu.be/IVgjqL2AL2s?si=ebcarE-nkWiQxi5P" target="_self">video</A></P> Thu, 13 Mar 2025 16:26:16 GMT Deku 2025-03-13T16:26:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4609003#M176431 <P>hi all,</P><P>&nbsp;</P><P>I am creating a report where I give the user the option to see the result in a matrix in units, thousands and millions. When they use units or thousands I do not want to have a decimal but when they choose millions the result in the matrix should have 1 decimal. How would you advice me to do this, when using Format the result will be a text field right?</P><P>&nbsp;</P><P>thanks,</P><P>Frank</P> Thu, 13 Mar 2025 16:21:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4609003#M176431 fjjpeeters1976 2025-03-13T16:21:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4609012#M176434 <P>Dynamic formatting</P><P>See this <A href="https://youtu.be/IVgjqL2AL2s?si=ebcarE-nkWiQxi5P" target="_self">video</A></P> Thu, 13 Mar 2025 16:26:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4609012#M176434 Deku 2025-03-13T16:26:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4612614#M176537 <P>Solved it with dynamic formatting</P> Mon, 17 Mar 2025 10:37:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Formatting-parameter-division/m-p/4612614#M176537 fjjpeeters1976 2025-03-17T10:37:04Z