Forum Discussion
Helper IDynamic Currency Format outside of table visuals?
Hey BenCardineau ,
you can do that with calculation groups. There you can change the way the text is displayed, but the number stays the same. For that reason you can also use it in charts.
Check the following tutorial on how to do that:
Change formatting of each individual value dynamically with Calculation Groups - What the fact.bi
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey BenCardineau ,
you can do that with calculation groups. There you can change the way the text is displayed, but the number stays the same. For that reason you can also use it in charts.
Check the following tutorial on how to do that:
Change formatting of each individual value dynamically with Calculation Groups - What the fact.bi
Helper IHi selimovd , you're a star!
It takes a while to get familiar with calculation groups (not so much the syntax in Tabular Editor, but more the fact you then must place the formatting 'measure' somewhere in the visual (in filter, or axis...). But other than this counter-intuitive usage of a formating measure, this is great!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Kudos to you!
Hi Ben,
Can you share your pbix files and some examples? I am facing the same issue and can't work it out although using the link provided.
Kind regards,
Tom
