Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |