The design of the dashboard is that the metrics used in there are all part of a dimension table. These help to create dynamic axis for the visual so that users can select the visuals they want to see.
Given the dynamic nature of the data selector, I cannot format the values in the table on their own ( for example, remove all decimal places would make the rate value 0 for all, a percentage value would affect variable * 100%). Therefore my initial attempt was to use the FORMAT function in dax to transform the measures we are using in the table.
I am converting the metrics into the desired format. However, doing this results in null values being converted into EMPTY values. The table should not contain the rows which are empty. However, these are EMPTY values rather than BLANK values so they only way I can remove them is by using the filter panel to filter them and set it to ‘IS NOT EMPTY’ however this really slows down the performance of the dashboard.
So I need an alternative approach that can change the format of the values in the table, that are being filtered by a slice of the metrics needed for the dashboard, whilst either not converting or easily removing the null values.
