Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hospital Data Question - NEED HELP ASAP

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 Powe...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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!