cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yuvalo Frequent Visitor
Frequent Visitor

Different values for index column while creating dynamic attributes

Hi,

I'm trying to create a dynamic attribute (so I can change the report if I want to see per geo,per type, per currency etc.) and I followed the instructions in the below link (and I saw similar explanations online), however when I create the idnex column and then duplicate and unpivot, the indexes stop representing the original rows, therefore my results are messed up (I changed the cross filter direction from single to both).

 

Any idea why this happens?

 

https://powerpivotpro.com/2018/01/dynamic-attributes-power-bi-report/

2 REPLIES 2
Community Support Team
Community Support Team

Re: Different values for index column while creating dynamic attributes

Hi @yuvalo ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
yuvalo Frequent Visitor
Frequent Visitor

Re: Different values for index column while creating dynamic attributes

Hi,

I can't share my data outside my organization. Also I tried it the same excersize on a smaller sample size and it seems to work, but when I go back to my original data the indexes are not acting the same.

Basically the problem is that after I unpivot the relevant columns the indexes for the original table and for the bridge table are not identical.

So I get the visual I want but the numbers are not accurate since the index does not refer to the correct row. Any idea why this happens?

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,169)