OKViz Bullet chart show change in absolute numbers as well as percentage

[E__]

Hi,

I'm using the OKViz Bullet chart. I've managed to configure the visual as I want it, but I want to show the change in absolute numbers as well as percentages. So far, I've only managed percentages. Is it possible to also show the change in absolute numbers?

Thanks in advance,

Best,

Eva

[v-kelly-msft]

Hi  @E__ ,

You can create a measure to calculate out the change first:

change = MAX('Table'[update])-MAX('Table'[value])

Then put the measure in the field of comparison value field,and you will see:

If this is not what you need,pls share me a screenshot of your expected output to make your requirement more clear.

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[E__]

Hi @v-kelly-msft ,

I'll clarify what I mean. I want last year's value, this year's value, and the change in percentage and absolute value. I've managed the first three, but I want something like this screenshot, in which I've added the change in absolute number myself.

Do you think something like this is possible. I don't think so, but just wanted to throw it out here, since someone might know a work around 🙂

Best,

Eva

[v-kelly-msft]

Hi @E__ ，

First create a measure to calculate out the differences between values;

Then put the measure in the field of "Targets";

Go to format>data lables:On,under data labels,set "show percentage change over ":"Compasion value";

And you will see:

Is it what you are looking for?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[E__]

Hi Kelly, @v-kelly-msft ,

Based on your workaround, I assume it's not possible to show only the number of the change in absolute value and also show it next to the change in percentage, as I did in my screenshot. Thanks for the help anyway!

Best,

Eva

[v-kelly-msft]

Hi @E__ ,

So how many values do you wanna show in the visual?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[E__]

Hi @v-kelly-msft ,

As I explained and as shown in my screenshot, I just want to add one extra number, i.e. the absolute change between the value and the comparison value. 

[v-kelly-msft · Accepted solution]

Hi  @E__ ,

Sorry for late reply.

Based on my test,it's not available to show  change in absolute numbers as well as percentage together.

But I have a workaround for you.

put the absolute numbers in the filed of "Tooltip",then when move the mouse to the details of the visual,you will see the value shown.

If the workaround is not satified,I suggest you propose an idea via below with your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

I had the opposite of what you want, i wanted to show the % but it doesnt.

Thanks

Vance

[amitchandak]

@E__ , I doubt. See if this can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview