https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-maintain-Data-formatting-after-Union/m-p/3029875#M103499 <P>I have a table which is a union of 2 tables ( A and B) - Table A contains values where as Table B Contains % value. I have a drop dop down filter with the values "Value" and "Percentage". So based on selection my unioned table will show correcponding data. how ever in the percentage select the values int hetable does not maintain "%" sign. Is there workaround so that I can get % sign in my Union table?</P> Thu, 19 Jan 2023 00:12:49 GMT Anonymous 2023-01-19T00:12:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-maintain-Data-formatting-after-Union/m-p/3029875#M103499 <P>I have a table which is a union of 2 tables ( A and B) - Table A contains values where as Table B Contains % value. I have a drop dop down filter with the values "Value" and "Percentage". So based on selection my unioned table will show correcponding data. how ever in the percentage select the values int hetable does not maintain "%" sign. Is there workaround so that I can get % sign in my Union table?</P> Thu, 19 Jan 2023 00:12:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-maintain-Data-formatting-after-Union/m-p/3029875#M103499 Anonymous 2023-01-19T00:12:49Z