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

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.