I have a DAX Measure with a Switch True Statement that retrieves some number values that must be displayed as general numbers and some as percentages. I want to display these values in a Line and Column Chart.
I’ve used the FORMAT() function around percentage values but the chart shows nothing. I think it is because the format function is turning the percentage values into a String.
How do I display these two different types of values appropriately in the Line and Column Chart, when either one or the other is retrieved by the Switch Statement?
Sample3_Revised.zip (574.3 KB)