cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

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

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

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

@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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors