How to change short values formatting for one language in a multi-language report?

[KeKaiser]

Hi!
I have built a multinaguage report and that works very vell, but I´m using the default buildt inn value formatting.
This works also fine for most languages, but some languages like Norwegian gives me an issue if I use Auto or other shortning options on large numbers. Where for most languages it would be shortened by the letter e.g. M for millinon (12M) in english.
But these sortnings is in Norwegian written out with full text e.g. 12 mill. and 12 tusen (thousand).
This makes the values take a lot of space and I´m from Norway and the normal way to shoten these numbers should be with just a letter. 

Dont like to change / set it for all languages as the buildt in formatting works very nice for most languages.
So anyone know how I kan change the value formatting for just some languages? 🙏

[mariussve1]

If you found my suggestions usefull, please accept it as Solution 🙂

Marius

[mariussve1]

Hi,

Could you maybe use  USERCULTURE()?

https://learn.microsoft.com/en-us/dax/userculture-function-dax

Returns the locale (language code-country code) for the current user, determined by the operating system, browser settings, or Power BI service.

I would try using this in a calculation group for Dynamic formatting in a if() statement.

Br

Marius, også fra Norge 🙂

[KeKaiser]

Hi @mariussve1 
(hyggelig med flere her fra Norge 🙂 )

We are setting the user USERCULTURE() and this works fine, where they who want to se the reports in English get the report translated to English and they who want to see it in Norwegian get it in Norwegian and so on for the other languages. 

All this works fine, it´s just that the values are setup with the buildt Power Bi in formatting of values for the different countries. This buildt in formatting works fine in most languages, but in some languages like Norwegian etc. it gives a not desireble result. There are a lot of values and DAX calculations so it will be a heck of a job to manually format all these values.

So am looking for if there is a solution that let me set/change this more global or at least at report page levle. Is it possible to make a if statement on top report level that will change all values formating for just the languages i choose?

Ketil / Brandcom.ai

[mariussve1]

Hi again 🙂

Yes, this is where Calculation Groups comes handy. You can create calculation group and put this on the filter pane for all pages:
https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups

Here is how you can use dynamic formatting:
https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups#add-a-dynamic-format-s...

If you have never worked with calculation groups before, I strongly recommend you to do some research on this before starting. One of the main things you need to understand is "implicit measures"!
You can google "power bi calculation groups implicit measures" or looke at this thread as a start:
https://community.fabric.microsoft.com/t5/Desktop/Calculation-groups-and-implicit-measures/td-p/3703...

I'm using calculation groups a lot, its really handy with time intelligence, and a lot of other use cases 🙂 So when you start using it, you will never go back.

Br

Marius

PS! Just to set a high level example:
The format string coud be stomething like this:
IF (  USERCULTURE() = "nb-NO", "Here you need to setup wich formatting you want",  SELECTEDMEASUREFORMATSTRING() )

SELECTEDMEASUREFORMATSTRING returns the orginal formatstring as you want 🙂

[KeKaiser]

Hi 
Thanks @mariussve1 for good tip, can I this way change the formatting for all values 
IF (  USERCULTURE() = "nb-NO" or do I need to spesify each column / measure?

If this can be done so it affects all values when  USERCULTURE() = "nb-NO" then its great and a solved case.

If it needs to spesify each measure or table column it will not work as they are many, usede in many reports and changes often.

Ketil

[mariussve1 · Accepted solution]

That is the purpose of Calculation Groups, it change all the measures you filter with it. So if you put it in a visual filter, it will change all the measures in that visual, if you put it on page it will change all the measures on that page, and if you put it on "Filter all pages" it will affect and change all the measures in the report 🙂

You can also put it in a slicer, so the end user can interact with it, or you can put it in a table or matrix on column.

Marius