Enlighten Data Story: value of format data

[mq2020]

Is there a way to specify the format of each data value in the Illuminate Data History visualization?

I'm using this visual to show the following:

Values 1st and 3rd are one % and 2rd and 4th are a text.

My measure that fills the 3rd value is actually formatted as %, however, it is not displayed in such.

Interestingly, when I change the order of measurements to make it look correct, but this does not help me!

[v-zhenbw-msft · Accepted solution]

Hi @mq2020 ,

We can use the FORMAT function to meet your requirement.

We create a sample and the measure like this,

% B = FORMAT(CALCULATE(SUM('Table'[value]),'Table'[name]="B") / CALCULATE(SUM('Table'[value]),ALL('Table')),"Percent")

% B = FORMAT(CALCULATE(SUM('Table'[value]),'Table'[name]="B") / CALCULATE(SUM('Table'[value]),ALL('Table')),"Percent")

You can replace the Bold with your number measure, like this,

% = FORMAT( [your measure],"Percent" )

BTW, pbix as attached that you can refer.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mq2020 

Refer, id this can help - https://blog.pragmaticworks.com/power-bi-custom-visuals-enlighten-data-story

Or you can create formatted measure to use - https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

Refer:https://community.powerbi.com/t5/Desktop/Enlighten-Data-Story-Conditional-Formatting/m-p/922690

As it is a custom visual connect developer