https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-format-returned-from-measure/m-p/2497474#M68946 <P>Never mind.&nbsp; You can freely apply formatting to the individual measures that are being referenced by the variable measure, making sure to maintain data types used in subsequent calculation.</P> Fri, 06 May 2022 04:02:32 GMT ghaines 2022-05-06T04:02:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-format-returned-from-measure/m-p/2497468#M68945 <P>I'm working with a measure that has a different output based on the selected column.&nbsp; When I use a DAX 'FORMAT' method to&nbsp;change the format for each column, the matrix visual begins to include rows with blank data (exactly as if the "Show items with no data" option was selected), ignoring filters.</P><P>&nbsp;</P><P>Manually filtering the rows is not an option.</P><P>&nbsp;</P><P>How can I apply a format without showing previously blank values in the visual?</P> Fri, 06 May 2022 03:58:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-format-returned-from-measure/m-p/2497468#M68945 ghaines 2022-05-06T03:58:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-format-returned-from-measure/m-p/2497474#M68946 <P>Never mind.&nbsp; You can freely apply formatting to the individual measures that are being referenced by the variable measure, making sure to maintain data types used in subsequent calculation.</P> Fri, 06 May 2022 04:02:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variable-format-returned-from-measure/m-p/2497474#M68946 ghaines 2022-05-06T04:02:32Z