Using Microsoft Bullet chart in reverse order

[Dave-ExpSC]

I am using the Microsoft Bullet Chart but the data I want to display better when it is smaller. I saw a post where someone wanted to do both options in the same chart and it was said that this is not available yet. I just want to do smaller is better.

I have tried reversing the color scheme and using negative data values. It gets very confusing. Does someone have a recommendation for how to best trick the chart to display improvement when the values get smaller?

Here is the bullet chart that I am using. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000933?tab=Overview

Thanks for any help!

[slongtin]

I know this is an old thread, but I stumbled upon a way to do this, sort of. I found that if I logically reverse my target and minimum values, and then reverse the colors, it seems to work.

For example, I have a metric where the "best" case (target) is 5 days and the "worst" case (minimum) is 10 days. If I reverse those, so that the best case goes into the minimum slot and the worst case goes into the target slot, then suddenly my bullet chart built in a somewhat sensible fashion. Then I reversed the colors and adjusted the ranges as needed.

[Anonymous]

HI @Dave-ExpSC,

It seems like you are work with a third party custom visual. I don't think you can customize its default color mapping. Maybe you can contact to visual author to know more about that visual and the advanced tricks.

Regards,

Xiaoxin Sheng

[parry2k]

@Dave-ExpSC so converting the values to negative will not do it? The highest value when converted to negative will be the lowest value and the lowest value when converted to negative will be the highest value, just thinking aloud here.

[Dave-ExpSC]

It seems that reversing the color scheme should do it but it gets confusing when then trying to make the Data Values work - either through Data or Format. Do you think reversing the color scheme is a step in the right direction?