Use a single value to return multiple metric in bar chart?
Hello all! I have a question, I have a dataste set which looks into sum of Savings Balance for Dec'23 and for Mar'24. I have it summed up and displayed like this in bar Now I need to add a Fixed Deposit metric also that again look into sum for Dec'23 and Mar'24. I figured that having a filter that I can use to switch between Saving Account and Fixed Deposit metric for two dates would be smart, but I cant seem to form a filter that works. I made a new table called Measure Table with the below column, with these options, then a new measure, but it doesnt work. I think im missing something but not sure if theres a way to create a filter that shows value for Savings & FD. SA = IF(CONTAINS('Measure Table', 'Measure Table'[Metrics], "CASA"), [DEC'23], [Mar'24]) If any help that would be great! Thank You!
Metric Switch Formatting Error
I have two metric switch statements. One switch returns the current week data, the other switch is the prior 6 week data. I need to create a Varience between the two, so I need to subtract the two metric switch statements. The issue is that in both metric switch statements, there are 2 measures that need to be formatted as % and I receive an Error: "Cannot convert value '%' of type Text to type numeric/date. I am only formatting the measures to % in the metric switch statements, since metric switchs change data type to default. (Images Below) Note: The formatting of the % works properly in each individual metric switch, just not when I subtract the switches together. I am not sure why I am getting this error when the formatting is the same in the two switch statements. I have been able to subtract metric switch statements in other meausres to get Var, but they didnt have formatting on them. Is there a workaround for this issue or am I just missing something? Thanks in advance!
