Forum Discussion
Data not available
hi klehar
You can apply a dynamic format string to the % Quote Esc QTD measure. This approach retains the same data type but changes the format based on specific conditions. In the screenshot below, I’m applying a dynamic format string to the Sum of Value measure, depending on the value of the Sum of Value by Month measure. The purpose is to ensure that formatting is only applied if the total monthly value is zero and not to all zero values from past months. In your case, this will display "N/A" for 0.0% in December if the dynamic format string is based on the same measure in your table. Alternatively, you could use the FORMAT function, but that would convert the result into a text string. Instead, use "0.00%" as the format string rather than "#,#". Please refer to the attached PBIX file for details.
agreed with you ,great solutions
danextian thanks for the response. However in real life sceanrio my date is conencted through a date dimension.
That isnt working with the allexcept
In my date table I have 4 values, included 202502 feb as well against which there is not even a 0entry in the fact table
Apply ALLEXCEPT to your dates table. I applied that a different table because no sample data was provided and whipped up something for the sake of illustration. Also, your showing 0% in your viz so apply ALLEXCEPT to the same measure as that that is measure you'll want to apply dynamic format string to.
