Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |