0 Kudos

How to know sequence of column used in pivot table

Status: Delivered
by dipparma1309 Visitor on ‎02-08-2019 02:54 AM

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
by Moderator v-yuezhe-msft
on ‎02-11-2019 09:44 PM

@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

by Moderator v-yuezhe-msft
on ‎02-11-2019 09:44 PM
Status changed to: Delivered
 
Idea Statuses