To show index column centered at 100 and bars diverging to show under/over indexed

[Anonymous]

Hi all,

I have a table with 2 columns- 1st is an entity column and 2nd is an index column. I want to have a bar chart centered at 100 to show the entities that are under-indexed or over-indexed( kind of divergent chart centered at 100).
There is an option to start the X-axis with 100 in a bar chart but this obviously eliminates the entities whose index is less than 100.

It would be great if anyone could help.

Sample data-

Entity	Index
A	130
B	122
C	78
D	50
E	59
F	100
G	102
H	88

Sample chart-

Thanks.

[amitchandak]

@Anonymous , I doubt measure can help to move axis at 100 . You can have two meausre - 100 and 100 -measure  and but those on tornado 

[amitchandak]

@Anonymous , Power BI has tornado visual. But I doubt that can do this - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380768?tab=Overview

[Anonymous]

@amitchandak, I tried tornado chart. But it isn't working. I thought a DAX measure would help.