Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Good visual for this data

Hi Team,

I have data for Q1,Q2,Q3,Q4, I want to show in Quarter data for project. Project is used as filter, I want Q1 Q2 Q3 Q4 in axis but all this are calculated columns

Here is sample of my data.

ProjectQ1Q2Q3Q4
ACompletedDelayedCompletedCompleted
BDelayedCompletedDelayedDelayed
CDelayedDelayedDelayedCompleted
DNACompletedDelayedCompleted
ECompletedCompletedCompletedCompleted
FNACompletedDelayedNA
GDelayedDelayedDelayedDelayed
HCompletedDelayedNACompleted
IDelayedNACompletedDelayed
JCompletedCompletedCompletedDelayed
KCompletedCompletedNACompleted
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , need unpivoting, but for that can these be created in power query .

     

    If you have an independent table with rows as Q1, Q2, etc

     

    Qtr Table

     

    Qtr

    Q1

    Q2

    Q3

    Q4

     

     

    Switch( True() ,

    max(Qtr[Qtr]) = "Q1" , Max(Table[Q1]) ,
    max(Qtr[Qtr]) = "Q2" , Max(Table[Q2]) ,
    max(Qtr[Qtr]) = "Q3" , Max(Table[Q3]) ,
    max(Qtr[Qtr]) = "Q4" , Max(Table[Q4])
    )

     

    Use Qtr from Qtr Table 

    and Project from your table 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak ,

      Why ?

      Switch( True() ,

      max(Qtr[Qtr]) = "Q1" , Max(Table[Q1]) ,
      max(Qtr[Qtr]) = "Q2" , Max(Table[Q2]) ,
      max(Qtr[Qtr]) = "Q3" , Max(Table[Q3]) ,
      max(Qtr[Qtr]) = "Q4" , Max(Table[Q4])
      )