Hospital Data Question - NEED HELP ASAP

[Anonymous]

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

[v-eqin-msft · Accepted 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

Here is the pbix file.

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

[Anonymous]

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!

[jdbuchanan71]

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

[jdbuchanan71]

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.

[Anonymous]

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