cancel
Showing results for 
Search instead for 
Did you mean: 
0

How to know sequence of column used in pivot table

Hi Team,

 

I have created model in SSAS and connecting this model into PowerBI. I have created one measure in model which should change dynamically based on dimension used pivot table in sequence.

 

Ex. I have three column A,B,C . User has used first A then B and Then C as column sequence in pivot table . If user used column C as last column in pivot table then my measure should display some value. Same user can drag this column in different sequence also. Ex.. B,C,A then last column is used A then some different measure value should be displayed in measure.

 

Is they any way to identify which column is used last in pivot table. Thanks in advance

Status: Delivered
Comments
Moderator

@dipparma1309,

I don't think the above requirement can be achieved in Power BI Desktop. It is not possible to determine the column sequence and dynamically show different measure values.

Regards,
Lydia

Moderator
Status changed to: Delivered