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:    ...
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

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