Forum Discussion

Shakti_Janki's avatar
Shakti_Janki
New Member
9 years ago
Solved

Grouped view in Visual

Hi,

 

I'm new at this. Hopefully someone can help me.
Problem: i want to see 1 number and behind it, per status, OK or NOT OK. Can anyone tell me how to do that?
Example made in Excel: 

 

The check if something is OK or NOT OK is working with de DAX formula. 

 

This is how the data looks that i am using.

Data:

 

This is how the visual looks like now:

 

I'm hoping someone can help me :).

Grtz,
Shakti Janki

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Shakti_Janki,

     

    I am unable to reproduce your issue. In my test, I created a calculated column which returned OK/Not OK based on source table. Then, I used a matrix visual to display data, add [Nummer] into Rows section, add [Status] into Columns section and add the new column into Values section.

     

    In your scenario, it seems that the data was not grouped based on [Nummer] in visual, how did you make the DAX formula?

     

    Regards,
    Yuliana Gu

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    Shakti_Janki

     

    it makes sent to pivot in power query in my mind. but there might be a better way to do this

    https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-common-query-tasks/  (look under the pivot section)

     

    this is what i would do

     

    1. in power query add a custom column with a value "ok"

    2. pivot on the status column using the custom column as your value

     

    what you will end up with is all your columns like your first graph except there will be 1 and 0, 1 = ok, 0 = not ok.  

     

     

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi Shakti_Janki,

     

    I am unable to reproduce your issue. In my test, I created a calculated column which returned OK/Not OK based on source table. Then, I used a matrix visual to display data, add [Nummer] into Rows section, add [Status] into Columns section and add the new column into Values section.

     

    In your scenario, it seems that the data was not grouped based on [Nummer] in visual, how did you make the DAX formula?

     

    Regards,
    Yuliana Gu

    • Shakti_Janki's avatar
      Shakti_Janki
      New Member
      9 years ago

      Hi v-yulgu-msft,


      Thanks! I think i got it right now. The first thing was that i was not using the Matrix visual, but the Table visual.
      When i changed that, i followed you advice to add [Nummer] into Rows section and added the new columns into the Values section. These changes resulted in this:

       

      The DAX formula i used was: Impact analyse akkoord = IF(Query1[Status]="Impact Analyse geaccordeerd";IF(Query1[Functie]="FB";"OK";IF(Query1[Functie]="ICT Beheerder";"Akkoord";IF(Query1[Functie]="Changemanager";"Akkoord";"Niet akkoord")))) 

       

      Thanks for all your help!
      Also vanessafvg