Index Calc - Finding Segment Index relative to Overall Aggregate Response Rate

[vikash-jamnadas]

Hi All

I am trying to calculate Index for each Segment in Powerbi.  Attached is summary level data what I have done in excel.  

1. Really would appreciate is someone can assist with a DAX formula to calculate Segment Index?  Following is what I did in Excel. Please note that it is summaryy level data in Excel.

Segments	% Response	Index
Seg. 1	2.90%	94
Seg. 2	3.10%	100
Seg. 3	3.70%	119
Seg. 4	3.30%	106
Seg. 5	2.90%	94
Seg. 6	4.00%	129
Seg. 7	3.40%	110
Seg. 8	2.70%	87
Seg. 9	4.90%	158
Total	3.10%	100

2. How can this be graphed in PBI so that the vertical axis crosses horizontal axis at index of 100?

Thanks in advance for all the assistance.

Kind Regards

Vikash

[v-easonf-msft · Accepted solution]

Hi @vikash-jamnadas 

Maybe you can try a visual called “Bar chart with relative variance” . Create a measure to specify a standard value and place it in the place of Plan .Put Index in Actual .Then you can see the diff between the standard value and Index .

Measure = 100

I have attached my pbix file , you can refer to it .

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@vikash-jamnadas , This seems like Tornado chart,

if you can not switch axis, you might have subtract value 100 from measure

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