Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
vikash-jamnadas
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% ResponseIndex
Seg. 12.90%94
Seg. 23.10%100
Seg. 33.70%119
Seg. 43.30%106
Seg. 52.90%94
Seg. 64.00%129
Seg. 73.40%110
Seg. 82.70%87
Seg. 94.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?

 

vikashjamnadas_0-1646259427284.png

 

Thanks in advance for all the assistance.

Kind Regards

Vikash

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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

veasonfmsft_0-1646633813219.png

veasonfmsft_1-1646633813220.png

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.

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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

veasonfmsft_0-1646633813219.png

veasonfmsft_1-1646633813220.png

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
Super User
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

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors