topic Re: To show index column centered at 100 and bars diverging to show under/over indexed in DAX Commands and Tips

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

Anonymous — Tue, 24 Nov 2020 15:49:59 GMT

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.

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

amitchandak — Tue, 24 Nov 2020 15:58:53 GMT

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

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

Anonymous — Tue, 24 Nov 2020 16:14:56 GMT

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

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

amitchandak — Wed, 25 Nov 2020 02:23:06 GMT

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