Forum Discussion
Filtro por VALOR ou QUANTIDADE
- 5 years ago
Hi PedroAliança
Do you use the switch measure in the table visual, line chart visual and bar chart visual? I think it is because these charts expect numeric values to display whereas the measure returns Text type value when using Format function.
Using Calculation Groups may help solve this. I remembered I read a post earlier which used calculation groups to switch the format without changing data types, but I haven't used that before. You may first read Dynamic Formatting of Switch Measures - Excelerator BI and try this method.
Sorry for not providing a solid solution. I will try my best to find another option.
Regards,
Jing
Hi PedroAliança
Do you use the switch measure in the table visual, line chart visual and bar chart visual? I think it is because these charts expect numeric values to display whereas the measure returns Text type value when using Format function.
Using Calculation Groups may help solve this. I remembered I read a post earlier which used calculation groups to switch the format without changing data types, but I haven't used that before. You may first read Dynamic Formatting of Switch Measures - Excelerator BI and try this method.
Sorry for not providing a solid solution. I will try my best to find another option.
Regards,
Jing
Hi Jing!
Eu fiz esse metódo pelo Tabular Editor e funcionou perfeitamente!
Muito obrigado pela ajuda!
- v-jingzhang5 years ago
Community Support
That's great! Cheers!