Power BI for Business Users (Beginners Welcome)

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Need help with creating a chart using multiple fields

  • 1.  Need help with creating a chart using multiple fields

    Posted Jul 30, 2021 11:49 AM
    Edited by Raj Kumar M Jul 30, 2021 12:02 PM
      |   view attached
    Hello,

    I need to find the count of instances each value is repeating from 3 columns. This is a mock dataset and the actual data set has 7 columns which are divided into three sections.

    When I try to combine all the 7 fields in the matrix view, it is adding the values from second through seventh fields into a single record which can be viewed when expanded.

    Can someone please help me with that?

    Thanks,
    Raj

    Attachment(s)

    xlsx
    Shifts.xlsx   12 KB 1 version