Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I am trying to figure out how to make it so that the fields that state "No Injury Reported" and slots that are completely blank don't show up in the charts and tables that I create in Power BI. Here is a sample of the data I am using. Any immediate assistance would be greatly appreaciated. Please explain any steps that you took to remove them from the charts without deleting it from the Excel Sheet table.
Thank you,
CATEGORY | LOCATION | NURSE PRESENT | OUTCOME |
Unanticipated | HEART | No | No Injury Reported |
Unanticipated | HEART | Yes | No Injury Reported |
Unanticipated | HEART | Yes | Mild / Minor Injury |
Accidental | HEART | No | No Injury Reported |
Accidental | HEART | No | Major |
Accidental | HEART | No | No Injury Reported |
Unanticipated | HEART | Yes | No Injury Reported |
Accidental | HEART | No | Mild / Minor Injury |
Suspected | HEART/LUNG UNIT | No | No Injury Reported |
Unanticipated | HEART/LUNG UNIT | No | No Injury Reported |
Accidental | HEART/LUNG UNIT | Yes | No Injury Reported |
Anticipated | HEART/LUNG UNIT | No | Mild / Minor Injury |
Unanticipated | HEART/LUNG UNIT | Yes | No Injury Reported |
Unanticipated | HEART/LUNG UNIT | No | Mild / Minor Injury |
Anticipated | HEART/LUNG UNIT | No | Mild / Minor Injury |
Accidental | HEART/LUNG UNIT | Yes | No Injury Reported |
Unanticipated | HEART/LUNG UNIT | No | Mild / Minor Injury |
Unanticipated | HEART/LUNG UNIT | No | Mild / Minor Injury |
Accidental | HEART/LUNG UNIT | No | No Injury Reported |
Accidental | HEART/LUNG UNIT | No | |
Unanticipated | HEART/LUNG UNIT | No | No Injury Reported |
Unanticipated | DAY SURG | Yes | No Injury Reported |
Unanticipated | DAY SURG | No | Mild / Minor Injury |
Accidental | DAY SURG | No | Mild / Minor Injury |
Unanticipated | DAY SURG | Yes | No Injury Reported |
Unanticipated | DAY SURG | No | No Injury Reported |
DAY SURG | Yes | No Injury Reported | |
Accidental | DAY SURG | No | No Injury Reported |
Accidental | DAY SURG | No | No Injury Reported |
Accidental | DAY SURG | No | Mild / Minor Injury |
Accidental | MOTHER BABY | No | No Injury Reported |
Unanticipated | MOTHER BABY | Yes | No Injury Reported |
Solved! Go to Solution.
Hi @Anonymous ,
According to my understand , you want to remove the rows when the Outcome is blank or =No Injury Reported and then sort by severity of injury, right?
You could use the following to create a new table:
Table 2 =
ADDCOLUMNS (
FILTER (
'Table',
'Table'[OUTCOME] <> "No Injury Reported"
&& 'Table'[OUTCOME] <> BLANK ()
),
"Flag", SWITCH ( [OUTCOME], "Mild / Minor Injury", 1, "Moderate ", 2, "Major", 3 )
)
Then sort the Outcome column by Flag column
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Anonymous ,
According to my understand , you want to remove the rows when the Outcome is blank or =No Injury Reported and then sort by severity of injury, right?
You could use the following to create a new table:
Table 2 =
ADDCOLUMNS (
FILTER (
'Table',
'Table'[OUTCOME] <> "No Injury Reported"
&& 'Table'[OUTCOME] <> BLANK ()
),
"Flag", SWITCH ( [OUTCOME], "Mild / Minor Injury", 1, "Moderate ", 2, "Major", 3 )
)
Then sort the Outcome column by Flag column
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Thank you!! I used the filters before but wasn't sure if there was a way to also remove it from the Excel sheet without ruining how the data is displayed in Power BI.
Is there a way to change the order of a category on a chart?
Example, on the Axis portion of the chart, the Outcome list Major, Mild and Moderate events. It is listing them in alphabetical order but I would like it to be listed as Mild, Moderate and Major. Can that be changed?
Thanks again for any assistance!
You have to have a numeric column that defines the sort order you want to use then in your model you set the sort order of the category column by the category_sort column. Here is an article about the subject.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
You can also set a report level filter for outcome and remove BLANK and 'No Injury Reported'. That way all visuals will be filtered to exclude those rows.
Hi @Anonymous - You can use filters to exclude No Injury reported or Blank.
Click on chart> in filters panel > Outcome is not 'No Injury Reported' etc.
Hope this helps.
Cheers,
-Namish B
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
104 | |
93 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
101 | |
95 |